Answer / nilesh

There are 2 types of triggers as per the execution goes
they are ROW LEVEL and STATEMENT LEVEL TRIGGERS

Then as per action triggers can be executed for three
actions as INSERT, UPDATE and DELETE

and trigger can also be executed before the action or after
the action . So with this we can have 12 diffrent triggers
they are: (6 Row level, 6 statement level)

ROW LEVEL
AFTER INSERT , BEFORE INSERT (2 Nos.)
AFTER UPDATE , BEFORE UPDATE (2 Nos.)
AFTER DELETE , BEFORE DELETE (2 Nos.)

STATEMENT LEVEL
AFTER INSERT , BEFORE INSERT (2 Nos.)
AFTER UPDATE , BEFORE UPDATE (2 Nos.)
AFTER DELETE , BEFORE DELETE (2 Nos.)

Answer / biswajit biswal

We can specified 28 Database triggers on a single table.

Before Row level insert
After Statement level update
Delete
insert or update
update or delete
insert or delete
insert or update or delete

2*2*7=28

I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS

7 Answers   Polaris,

---

What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

4 Answers  

---

What are the dml statements?

0 Answers  

---

What is the need of a partition key?

0 Answers  

---

What type of database is sql?

0 Answers  

---

What is the difference between partitioning and sharding?

0 Answers  

---

With out using count() function. How to the find total number of rows in a table?

6 Answers  

---

Where the integrity constrints are stored in Data Dictionary?

1 Answers  

---

What is difference between db2 and sql?

0 Answers  

---

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

0 Answers  

---

is it possible to pass an object or table to a procedure as an argument?

0 Answers  

---

Which nosql database is best?

0 Answers  

---