Answer Posted / dhanalakshmi parthasarathy

Triggers are simply stored procedures that are ran
automatically by the database whenever
some event (usually a table update) happens. We won’t spend
a great deal of time talking
about how to write triggers, because if you know how to
write stored procedures, you already
know how to write triggers. What we will discuss is how to
set them up to be executed whenever something happens to
the table.

What is an oracle cursor variable?

1085

---

What is oracle server autotrace in oracle?

1171

---

Why does oracle 9i treat an empty string as null?

1068

---

Explain mutating triggers.

1035

---

What are the different oracle database objects?

1103

---

How to use "in out" parameter properly?

1055

---

How to assign query results to variables?

1057

---

How to use subqueries in the from clause in oracle?

1116

---

Explain what are the characteristics of data files?

1087

---

what are the default admin accounts in Oracle 10g ?

977

---

Explain what are the uses of rollback segment?

1021

---

How to create an oracle testing table?

1078

---

Explain self joins in oracle?

1025

---

Can we store pictures in the database and if so, how it can be done?

1047

---

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2503

---