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 does appl_top directory contain?

0 Answers  

---

what is the error you will get if field is referenced in wrong repeating frame?

1 Answers  

---

Where I can download D2K software?

2 Answers  

---

what is organization id

2 Answers   Wipro,

---

do i need to declare bind parameter before using in the query?

2 Answers   Satyam,

---

what is the purpose of standard cost update?

2 Answers   Satyam, Scan Steel,

---

Tell me some thing about SQL-LOADER.

2 Answers   IBM,

---

Steps for DFF registration

2 Answers   IBM, Savvis, Wipro,

---

cursor 1 and cursor 2 are there did you open both the cursors at a time or not?

2 Answers   Infosys,

---

what are the profiles

3 Answers   IBM,

---

How to compile the Forms & Reports in Linux Apps Server which are created in WindowsXP client?

1 Answers  

---

Hi all I am in big career dilemma. I am currently working as Oracle Apps functional consultant scm with 1 yr of exp. I am thinking to do mba. Hos it will work to di MBA in scm or operations. Please guide .

1 Answers   TCS,

---