Answer Posted / madhuri

Triggers are basically PL/SQL procedures that are associated
with tables, and are fired whenever a certain modification
(event) occurs. The modification statements may include
INSERT, UPDATE, and DELETE.

The general structure of triggers is:
CREATE [OR REPLACE]TRIGGER trigger_name
BEFORE/AFTER
INSERT/UPDATE/DELETE ON tablename
[FOR EACH ROW [WHEN (condition)]]
BEGIN
...
END;

Can we use ddl commands in pl sql?

1161

---

How many scalar data types are supported in pl/sql?

1055

---

what is collation? : Sql dba

1148

---

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1145

---

How do I run a sql query?

1016

---

What is the purpose of the partition table?

1049

---

what is acid property in database? : Sql dba

1029

---

Can we insert in view in sql?

1057

---

What is pivot query?

1068

---

What is where clause in sql?

1040

---

Is left join same as join?

990

---

How does sql store data?

910

---

what is blob? : Sql dba

1148

---

Determine if oracle date is on a weekend?

1039

---

What does joining a thread mean?

1019

---