What are the types of triggers ?
Answer Posted / rohit
I hv a question..
in my textbooks, triggers types are described as
1) table trigger
2) system event trigger
3) user event trigger
is this also right??
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How many disk partitions should I have?
How do you break a loop in pl sql?
What is cost in sql execution plan?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
Where not exists in sql?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What port does sql server use?
Show the cursor attributes of pl/sql.
Differentiate between syntax and runtime errors.
Is a table valued function object?
Is like operator in sql case sensitive?
What is input buffer in sql*plus?
Can we use insert statement in function?
What are the different type of joins in sql?