Un-Answered Questions { All }

Can a select statement fire a trigger?

660


What are conditional predicates?

587


Does a user_objects view have an entry for a trigger?

570


Explain some predefined exceptions.

588


Does user triggers have entry for trigger with compilation errors?

600


Explain 3 basic parts of a trigger.

841


Show code of a cursor for loop.

584


What does closing a cursor do?

766


How many triggers can be applied to a table?

600


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

622


Show the cursor attributes of pl/sql.

611


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

756


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

598


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

586


What packages are available to pl/sql developers?

603