Un-Answered Questions { SQL PLSQL }

What does closing a cursor do?

734


How many triggers can be applied to a table?

577


How would you reference column values before and after you have inserted and deleted triggers?

601


Show the cursor attributes of pl/sql.

584


Which data dictionary views have the information on the triggers that are available in the database?

730


What are the events on which a database trigger can be based?

568


What is out parameter used for eventhough return statement can also be used in pl/sql?

559


What packages are available to pl/sql developers?

568


What does the base_object_type column shows in the user.triggers data dictionary view?

548


What are the rules to be applied to nulls whilst doing comparisons?

723


Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

663


What are database links used for?

566


What are the uses of merge?

699


How is a process of pl/sql compiled?

574


Is it possible to create the following trigger: before or after update trigger for each row?

699