Answer / madhuri

Execution is exception is done in many ways.

An exception occurs when there is something wrong in the
code of pl/sql block.
Exception can be raised either in declarative,executable or
in exception section itself.
In case of nested blocks when an exception occurs in inner
block,it will try to find its handle in the same block,if
not then control comes out of inner block and executes the
handler in the outer block.

When exception occurs in declarative and exception
section,then control is propagated to the next outer block.

Answer / swapna

We use exceptions to check the status of our procs .. like
what to do if the things are not going smoothly as
expected . ie we insert errors in audit tables with
user,date-time,err code.

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy

6 Answers   Target,

---

Maximum how many triggers can we use in trigger and How to find out how many records it fetched.

1 Answers   TCS,

---

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

0 Answers   MCN Solutions,

---

What is scalar function in sql?

0 Answers  

---

define different types of trigger. : Sql dba

1 Answers  

---

Why do we need cursor in pl sql?

0 Answers  

---

Why is sql better than hql?

0 Answers  

---

What are types of exception?

0 Answers  

---

what is outer join? what is selef join? what is difference between them? what is cartecion join?

1 Answers   Fiserv, Herbinger, Synechron,

---

what is the cursor and use of cursor in pl/sql ?

4 Answers  

---

What is sql query limit?

0 Answers  

---

How is indexing done in search engines?

0 Answers  

---