Un-Answered Questions { SQL PLSQL }
What is a call statement? Explain with an example.
If a cursor is open, how can we find in a pl/sql block?
Explain polymorphism in pl/sql.
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
Is it possible to pass parameters to triggers?
What are the different types of triggers?
Explain the uses of database trigger.
Can a commit statement be executed as part of a trigger?
Can a select statement fire a trigger?
What are conditional predicates?
Does a user_objects view have an entry for a trigger?
Explain some predefined exceptions.
Does user triggers have entry for trigger with compilation errors?
Explain 3 basic parts of a trigger.
Show code of a cursor for loop.
