Answer Posted / charan

Hi this is charan...
Actually Not allowed TCL commands in trigger...but it is possible we are not use directly these commands...to over come this problem oracle introduced one concept is called "Autonomous Transactions" .through autonomous transaction we are using tcl commands in Trigger concept....This is according to my knowledge

What are privileges and grants?

1063

---

How can I introduce multiple conditions in like operator?

980

---

What do you mean by a database transaction & what all tcl statements are available in oracle?

988

---

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

2329

---

What is rowid and rownum in oracle?

1005

---

What the is the diff between local index and global index. give some example.

1630

---

Explain about your project and its relation to the current job position you are applying to?

998

---

What happens if you use a wrong connect identifier?

1051

---

How to start your 10g xe server?

1029

---

What is null value in oracle?

1092

---

What is a static data dictionary in oracle?

1098

---

How to define an anonymous procedure with variables?

1146

---

Can we use bind variables in oracle stored procedure?

944

---

How to use existing values in update statements using oracle?

1055

---

How do I limit the number of oracle database connections generated by weblogic server?

1060

---