How many types of trigger can be used in a table at a time?
Submitted by: AdministratorWe 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Forms Reports Job Interview Questions And Answers
Top Forms Reports Questions
| ☺ | How to call a URL from a menu using Oracle Forms 6i? |
| ☺ | When to use Place holder columns in Oracle Reports and what is a place holder column? |
| ☺ | How to call a report from Forms? |
| ☺ | How to restrict a parameter list with parameters? |
| ☺ | How to hide the report in Apps? |
Top DB Oracle Categories
| ☺ | Oracle PL-SQL Interview Questions. |
| ☺ | Oracle DBA Interview Questions. |
| ☺ | Oracle D2K Interview Questions. |
| ☺ | OCI Interview Questions. |
| ☺ | Oracle RMAN Interview Questions. |
