What is cursor? Explain the types of cursor and write one implicit cursor program to check how many records deleted from table?
Latest Answer : Two types of trigger are there1. Row level trigger2. Statement level trigger ...
What are the different types of collections supported in Oracle?PL/SQL datatypes TABLE and VARRAY, allow us to declare the collections nested tables, associative arrays, and variable-size arrays.
If anyone asks in interviews, about "what are the types of triggers" then my ans is likerow level,statement level,before,after,insert,update,delete 3*2*2 total 12 types.and can i even mention instead of triggers,database trigger and schema triggers
What are the types of triggers in PL/SQL and in forms?in pl/sql, My guess is:row level, statement level,before,after,insert,update,deleteare there any triggers i missed, let me know?Thanks in advance.
Latest Answer : Collection is an ordered group of elements all are of same time. Each element in the collection has unique subscript to identify its position in the collection.Pl/sql offers three collection types.1. Nested table2. Varray3. Index by table Use collection ...
Explain share and exclusive type of lock.