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

what is the differences between internal requisition and internal sales order?

2643

---

Can you explain the difference between architecture followed in 10g & 11g?

1052

---

Explain oracle apps architecture.

1222

---

What do you understand by soa?

1130

---

how can develope the po variance and po summary report? with tables mandatory columns and query please?

2363

---

What is count(*) from po_vendors(any table)?

1074

---

List the various types of value set.

1072

---

what is the difference between request group and request security in oracle apps?

5870

---

How many schemas we have? how many you have used?

2044

---

pls send me out bound code of supplers,site,bankiformation code pls as soon as

2243

---

Hi  Friends this is preetham, i am  searching for job on oracle apps(technical) i put 3 years fake exp, so any one  please could you help me for realtime interview  questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify

2037

---

What is a flexfield? List out its types.

1147

---

What do you understand by a set of books?

1099

---

In sequence i want to 11 and 15th values how we will write?

2064

---

Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

2112

---