Explicit: For queries that return more than one row, explicit cursors are declared and named by the programmer and manipulated through specific statements in the block’s executable actions.Implicit: Implicit cursor are declared by pl/sql implicitly for all dml and pl/sql statements, including queries that return only one row.It opens an area of memory where the query is parsed and executed. Always use a variable to get the return value.Īnswer: Cursor is a sql private work area. from other procedures or functions or packagesįunctions can be called in the following ways:.

Q5) Explain how procedure and functions are called in a pl/sql block ?Īnswer: Procedure can be called in the following ways:

Number (9, -11) means that there are 9 digits whereas the rest is zero padded towards left of the decimal point Like 99999999900000000000.0.

However as the max precision is 9 so the rest are zero padded.

Number (9, 11) means there are 11 digits after decimal.

Q4) Can we declare a column having number data type and its scale is larger than precision ex: column name NUMBER (10,100), column name NUMBER (10,-84)Īnswer: Yes such declaration is possible. When the triggering statement is committed or rolled back, work in the trigger is committed or rolled back as well.Because it is fired as part of the execution of the triggering statement.Triggers should not contain transaction control statements like commit, rollback, savepoint or set transaction.Q3) Can commit, rollback, savepoint be used in database triggers? If yes then how? If no why? With reasons

You have to declare the second package with its arguments (if have) before using in the definition of first procedure it is labeled as forward declaration.If you are defining a package body having two procedures, if you want to use second procedure in the definitions of first procedure.Q2) What is meant by forward declaration in functions? Q1) What is the starting oracle error number ?Īnswer: ORA-00000 is the staring oracle error number. GangBoard offers Advanced PL/SQL Interview Questions and answers that assist you in splitting your PL/SQL interview and procure dream vocation as PL/SQL Developer. In case you’re searching for PL/SQL Interview Questions and answers for Experienced or Freshers, you are at the correct place.

Pl sql developer 10