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 USE OF SKIP WHERE U WILL GIVE?

3 Answers  

---

How You Will display the key flexifields in your report

3 Answers   TCS,

---

what is the defference between credit memo and debit memo

2 Answers  

---

In a package have predefined exception and user defined exception. while execution which exception will be executed first? why?

1 Answers   Oracle,

---

explain o2c cycle? what are the table reflected for this process?

1 Answers   BirlaSoft,

---

How relation will be made between modules in oracle financial?

4 Answers   HCL, Wipro,

---

which is the table for storing organization information?

9 Answers   Infosys, Scan Steel,

---

q)what are the validations in sql*loader

0 Answers   Accenture,

---

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

0 Answers  

---

what is the back ground program run while transferring data from OM to AR?

4 Answers   Qwest,

---

in sql *loder how to skip the middle records ex:from 10th to 20th records i want to skip?

2 Answers   Oracle, Schneider,

---

In Per_all_people_f table what is the significance of '_f ' ?

6 Answers   HCL,

---