-
-
Difference between Oracle 8i and Oracle 9i as a Developer
What are the diffrences between Oracle 8i and Oracle 9i as a Developer, not as a DBA??
-
-
-
-
-
-
What is the basic structure of PL/SQL ?
PL/SQL uses block structure as its basic structure. Anonymous blocks or nested blocks can be used in PL/SQL.
-
What are the datatypes a available in PL/SQL ?
Some scalar data types such as NUMBER, VARCHAR2, DATE, CHAR, LONG, BOOLEAN.Some composite data types such as RECORD & TABLE.
-
-
-
-
-
-
Pragma Init Exception
What is Pragma Init Exception ? what is difference between user defined exception and init pragma exception. what is the use of it.
-
-
Oracle - Could not find the Program unit
While i compiled my code , it got compiled but while running my application i got the Oracle error "Could not find the Program unit ? "Can any one tell exactly why this happens.I had validated all the objects and even released all the Locked objects . But still this error persisted .
-
Pl/SQL coding help
User Interface accepts the Employee information and this data needs to be compared with the existing data and the differences needs to be populated through a Pl/SQL table.Create a type (EMP_DATA) to populate the Employee table data.Create a type (ERR_TABLE) with the following attributes:ERR_NO NUMBER,ERR_COLUMN VARCHAR2(50),ERR_RESULT VARCHAR2(500)Create a package USER5_PKG1 with two procedures....
-
-
PL/SQL Interview Questions
Ans