Answer / Neha Bhoyare

"PRAGMA AUTONOMOUS_TRANSACTION is a compiler directive in Oracle PL/SQL. It allows a block of code to be executed within its own independent database transaction, which can commit or rollback independently from the main transaction. This is useful for implementing distributed transactions without deadlocks."n

How many types of table in Oracle?

1 Answers   MCN Solutions,

---

How to check your oracle database 10g xe installation?

1 Answers  

---

What is raw datatype?

1 Answers  

---

what are the advantages of running a database in NO archive log mode?

1 Answers  

---

What are the oracle built-in data types?

1 Answers  

---

SQL> CREATE TABLE to_table 2 (col1 NUMBER); Table created. SQL> CREATE OR REPLACE TRIGGER statement_trigger 2 AFTER INSERT ON to_table 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE('After Insert Statement Level'); 5 END; 6 / Trigger created. SQL> CREATE OR REPLACE TRIGGER row_trigger 2 AFTER INSERT ON to_table 3 FOR EACH ROW 4 BEGIN 5 DBMS_OUTPUT.PUT_LINE('After Insert Row Level'); 6 END; 7 / Trigger created. SQL> INSERT INTO TO_TABLE VALUES(1); After Insert Row Level After Insert Statement Level 1 row created. SQL> BEGIN 2 INSERT INTO TO_TABLE VALUES(2); 3 INSERT INTO TO_TABLE VALUES(3); 4 INSERT INTO TO_TABLE VALUES(4); 5 INSERT INTO TO_TABLE VALUES(5); 6 INSERT INTO TO_TABLE VALUES(6); 7 INSERT INTO TO_TABLE VALUES(7); 8 INSERT INTO TO_TABLE VALUES(8); 9 INSERT INTO TO_TABLE VALUES(9); 10 INSERT INTO TO_TABLE VALUES(0); 11 END; 12 / WAT LL BE THE O/P??? XPLAIN IT>>>>

1 Answers   Infosys,

---

Explain what does a control file contain?

1 Answers  

---

how do get database name at sql prompt?

3 Answers  

---

What is oracle rownum?

1 Answers  

---

What are the database administrators utilities available?

1 Answers  

---

what are views?

8 Answers   TCS,

---

What are the types of Database Links ?

2 Answers  

---