Answer Posted / abhisek pattnaik

Trigger is a type of programme which is automatically
executed when ever a DML operation is made on a perticular
table.
Trigger is identical with procedure but the basic
difference between them is procedure is explicitly created
& executed by the user where as trigger is explicitly
created but implicitly fired or executed when ever a DML
operation is made.

Can we store images in oracle database?

1005

---

What language does oracle use?

1098

---

How will you differentiate between varchar & varchar2?

1041

---

How index is implemented in oracle database?

1006

---

Explain oracle insert into command?

1110

---

Oracle

2375

---

How to define an anonymous procedure without variables?

1105

---

How can windows applications connect to oracle servers?

1057

---

When do you get a .pll extension in oracle? Explain its importance

1039

---

What is transaction control statement and how many types of transaction control statement in Oracle?

1155

---

What is a procedure in oracle?

1196

---

What is truncate oracle?

971

---

Which is faster join or subquery in oracle?

995

---

11. Display the client number and name and the client number and name of the person who referred that client.

2339

---

How to convert character types to numeric types?

1130

---