How many types of trigger can be used in a table at a time ?
Answers were Sorted based on User's Feedback
u can define a trigger
1. For Each Row
2. For Each Statement
You can have the following triggers defined for the above
two types:
1. BEFORE INSERT
2. BEFORE UPDATE
3. BEFORE DELETE
4. AFTER INSERT
5. AFTER UPDATE
6. AFTER DELETE
So it makes a total of 12.
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / shanmugavelu
Max 12 types we can use before/after combination
| Is This Answer Correct ? | 8 Yes | 4 No |
Use the Add_group_row procedure to add a row to a static record group 1. true or false?
in compatibility in report registration?
what is the difference between call_form, new_form and open_form?
Name of the functions used to get/set canvas properties?
What is the difference between SHOW_EDITOR and EDIT_TEXTITEM?
Please tell me what is wrong in the below query: (Very Urgent) ================================================= function BeforePForm return boolean is begin if :from_invoice_date is null OR :to_invoice_date is null then aiv.PERIOD_NMAE:=:gl_period elsif :gl_period is null then aiv.INVOICE_DATE between :from_invoice_date and :to_invoice_date end if; return (TRUE); end;
Can a field be used in a report wihtout it appearing in any data group?
What is summary column in Oracle Reports ?
what are the new features introduced in oracle form services in 11g release 2?
Can u explain me the Restricted and unrestricted procedure in Forms And reports and example as well ??
EXIT_FORM is a restricted package procedure ?
Explain the various types of oracle report?