Answer Posted / robert son das

There are total four(4) types of triggers..

they are:
before insert----row level
before delete--row level
before update--row level

before insert----statement level
before delete--statement level
before update--statement level

after insert----row level
after delete--row level
after update--row level

after insert----statement level
after delete--statement level
after update--statement level

instead of trigger--row level
instead of trigger--statement level

What will you get by the cursor attribute sql%found?

968

---

write an sql query to find names of employee start with 'a'? : Sql dba

1031

---

what are the types of join and explain each? : Sql dba

1042

---

What are the benefits of pl/sql packages?

1107

---

what is a field in a database ? : Sql dba

1067

---

What is sql entity?

1108

---

Explain the commit statement.

1165

---

What is sqlerrd?

971

---

What is program debugging?

1259

---

What are different types of keys?

1109

---

What does joining a thread mean?

1023

---

What are the key differences between SQL and PL SQL?

1220

---

Where the sql database files are stored?

1022

---

Can primary key be changed?

913

---

How run sql*plus commands that are stored in a local file?

1065

---