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 |
I HAVE A REPORT LAYOUT LIKE THIS RUNDATE -FIELD DEPTNO-FIELD ------------------------------------------------------------ ------------------- EMPNO-----ENAME------SAL-----COMM----MGR----- ------------------------------------------------------------ ------------------ ------- ------------ -------- -------- -------- MY REQUIREMENT IS I WANT DEPTNO 10 VALUES IN ONE PAGE,DEPTNO 20 VALUES IN ONE PAGE,AND 30 IN ONE PAGE. I WANT LIKE THIS ....
what is the exact navigation to create a radio button in form6i? can i create the radio button in report6i?
what are different types of canvas views?
While connecting to Oracle Db i am getting the following error message- ORA-12154: TNS:could not resolve the connect identifier specified what are the steps to solve this problem?
What is the content view and stacked view?
Can we use GO-BLOCK package in a pre-field trigger ?
how to create the triggers in the forms?
What are the types of trigger actions?
LOV can best describe a) window b)modal c)list d) none of these d)
if u have one group can u create another from that
What do you understand by oracle forms?
What is the usuage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS ?