Answer / p.rajasekar

Autonomous transactions are started by a parent, or main,
transaction but operate
independently of the parent for transaction control. If a
commit or rollback is used
in the autonomous or main transaction, or if a failure
occurs for any reason, it does
not impact the other transaction.
Our favorite use of this feature is for logging application
events. If the need is to
log activity, regardless of the outcome, but the logging
success or failure should not
impact the application, autonomous transactions are the
perfect solution.
To create an autonomous transaction, use a pragma called
AUTONOMOUS_TRANSACTION. The pragma is placed in the
declaration section of the block.

Answer / rasmita basantia

its mainly used in that schenario where u are interested to
perform independent transaction.

Answer / singh

eg: We can take a normal bank transaction. Each transaction
has two part one debit and other credit and if any one part
fails the whole transanction fails.

is it mandatory to select all the column in a view then what columns should be selected

2 Answers  

---

select sal from emp group by sal

3 Answers   TCS,

---

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

0 Answers  

---

Is pl sql still used?

0 Answers  

---

What is the difference between inner join and left join?

0 Answers  

---

---

What are all the ddl commands?

0 Answers  

---

What is Overloading of procedures ?

4 Answers   Amdocs,

---

hi..........i m Accenture employee...Accenture is an IT company having itz branches in India at Mumbai, Pune,Delhi, Hyderabad, Chennai and Bangalore....Presently there are openings here for SAP, Testing, Oracle,Java,.NET,MAinframe and Peoplesoft...... I am a software engineer working with Accenture,Mumbai....u can mail me in your resume..i`ll forward it to our HR team...my mail id: pankit.lodaya@accenture.com

8 Answers   Wipro,

---

What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?

9 Answers   Oracle,

---

Explain two easy sql optimizations.

0 Answers  

---

What is out parameter used for eventhough return statement can also be used in pl/sql?

0 Answers  

---

can i call procedure in package

3 Answers   TCS,

---