Answer / ramesh babu v

Autonomous transaction can be devided into two parts as
parent&child,both(parent&child) are run simultaniously and
individually run.
EX:
create table R1(B1 number);
Table created.
create table R2(B2 number);
Table created.
/

1 create or replace procedure p1
2 as
3 pragma autonomous_transaction;
4 begin
5 insert into R1 values(101);
6 commit;
7* end;
/
Procedure created.
/
select * from R1;

B1
---
101
/

> create or replace procedure p2
2 as
3 begin
4 insert into R2 values(102);
5 p1;
6 rollback;
7 end;
8 /
Procedure created.

SQL> select * from R2;

no rows selected.

Answer / ramesh

if we want to make one transaction as independent among other or parent transaction,we will use the concept call autanamous transaction,

we will use pragma autanamus_transaction keyword in order to make one transaction as independent,so this transaction will run idependently...

WHAT IS THE FORWARDREFERENCE IN PL/SQL?

4 Answers   IBM,

---

What are the different components of soa suite?

0 Answers  

---

whats the use of after parameter form and before report?

2 Answers   IBM,

---

In SQL Loader i have 100 Records to be loaded into my table. How do i load the first 30 Records and skip the last 10 Records within a single .ctl file ? So my total no.of records to be loaded would be 60. Could anybody help me in this ?

2 Answers  

---

What is the result of this query ? SELECT * FROM EMP WHERE ROWNUM = 1

25 Answers   IBM, Satyam,

---

What is SET-OF-BOOKS?

3 Answers  

---

what is instead of trigger in where u will use?

2 Answers   TCS,

---

where the accounting related data is stored ?

2 Answers  

---

How relation will be made between modules in oracle financial?

4 Answers   HCL, Wipro,

---

can we write sql statement in Format trigger?

4 Answers  

---

How to report output like below supplier name date amount abc software jan/11 10000 /* jan month total transactions*/ abc software feb/12 30000 /* feb month total transactions*/ dell computers jan/13 45000 /* jan month total transactions*/

4 Answers   Satyam,

---

how can we get odd numbered pages in output of a report

2 Answers   Infosys,

---