Answer / 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

Answer / karthik

yes, by autonomous transaction we can use commit.

Answer / vaibhav

No

Answer / usingh

Yes, using AUTONOMOUS_TRANSACTION Pragma you can COMMIT and ROLLBACK.

Explain cascading triggers.

0 Answers  

---

Explain what are the characteristics of data files?

0 Answers  

---

What is data file?

0 Answers  

---

What privilege is needed for a user to query tables in another schema?

0 Answers  

---

What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?

1 Answers   HDFC,

---

How do I manually uninstall oracle client?

0 Answers  

---

what is RAID technology?which is better RAID 0+1 OR RAID 5?

2 Answers   CSC,

---

Explain table?

0 Answers  

---

primary key is foreign key for the same table?

2 Answers   Oracle,

---

Explain the family trees and connection by clause

0 Answers  

---

5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.

3 Answers   Wipro,

---

How to commit the current transaction in oracle?

0 Answers  

---