|
Question |
Rating |
View Answer |
|
What are SQLCODE and SQLERRM and why are they important for PL/SQL developers? |
|
View Answer |
|
What is a mutating table error and how can you get around it? |
|
View Answer |
|
What are the types of triggers? |
|
View Answer |
|
Which set of statements will successfully invoke this function within SQL*Plus? |
|
View Answer |
|
Describe the difference between a procedure, function and anonymous pl/sql block. |
|
View Answer |
|
Why PL/SQL does not support retriving multiple records? |
|
View Answer |
|
What is the maximum number of handlers processed before the PL/SQL block is exited when an exception occurs? |
|
View Answer |
|
In what order should a open/fetch/loop set of commands in a PL/SQL block be implemented if you use the NOTFOUND cursor variable in the exit when statement? Why? |
|
View Answer |
|
Can we assign value to IN parameter inside a pl sql procedure? |
|
View Answer |
|
What are SQLCODE and SQLERRM and why are they important for PL/SQL developers? |
|
View Answer |
|
Which Oracle supplied package can you use to output values and messages from database triggers, stored procedures and functions within SQL*Plus? |
|
View Answer |
|
What are the types of triggers? |
|
View Answer |
|
Describe the difference between a procedure, function and anonymous pl/sql block. |
|
View Answer |
|
What packages (if any) has Oracle provided for use by developers? |
|
View Answer |
|
In what order should a open/fetch/loop set of commands in a PL/SQL block be implemented if you use the %NOTFOUND cursor variable in the exit when statement? Why? |
|
View Answer |
|
When is a declare statement needed ? |
|
View Answer |
|
How can you find within a PL/SQL block, if a cursor is open? |
|
View Answer |
|
How can you find within a PL/SQL block, if a cursor is open? |
|
View Answer |
|
When is a declare statement needed ? |
|
View Answer |