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

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2002

---

What are oracle functions?

974

---

Difference between inner join vs where ?

977

---

Can we protect our pl/sql source code?

992

---

Explain the use of tables option in exp command.

1052

---

How will you write a query to get a 5th rank student from a table student_report?

1813

---

Explain what are the uses of rollback segment?

960

---

Explain compound trigger in oracle?

986

---

How to convert characters to dates in oracle?

1023

---

how to handle exceptions in post production

1358

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4292

---

How to assign a tablespace to a users in oracle?

991

---

What are the parameters that we can pass through a stored procedure?

997

---

What is not equal to in oracle?

951

---

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2043

---