Answer / swati kapoor

User Defined exceptions are executed prior to system
defined exceptions.

User defined exceptions are executed in the order in which
they are defined.

When an exception is raised,normal execution of your PL/SQL
block or subprograms stops and control transfers to its
exception-handling part.

Note: When others should be handle in last of exception
handling part of block.

in ap_terms table what data will be stored

2 Answers   Wipro,

---

where we will put the control file ,where we will run sql star loader what is the cmd?

1 Answers   Cap Gemini, KPMG,

---

Can u define exceptions twice in same block?

3 Answers  

---

What will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?

2 Answers   TCS,

---

name at least five reports in oracle inventory related to transaction ?

3 Answers   Scan Steel,

---

---

what is mutating table and mutating error and how to solve that?

3 Answers  

---

can we use look up type instead of a pofile option?or valueset?is it possible how?

0 Answers   Cap Gemini,

---

Give a overview on Aol

2 Answers   Zensar,

---

what is count(*) from po_vendors(any table)? what does it do and what is count(1) from po_vendors(any table)? what is count(0) from po_vendors(any table) the out put is same what is the difference

4 Answers   IBM,

---

tell me the scenarios of the independent in reports

0 Answers   TCS, Wipro,

---

Hi Anil, When we importing the journals in GL module we need to insert the one row into GL_INTERFACE_CONTROL for each group_id.Now my question is what is the use of inserting the data into GL_INTERFACE_CONTROL table and if I not inserted into GL_INTERFACE_CONTROL what will happen

2 Answers   TCS,

---

List some exceptions other than NO_DATA_FOUND, TOO_MANY_ROWS and WHEN OTHERS

3 Answers   Satyam,

---