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.

What is a table?

0 Answers  

---

What is the process of copying data from table a to table b?

0 Answers  

---

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

0 Answers   Virtusa,

---

What is the use of sqlerrd 3?

0 Answers  

---

What is a left inner join?

0 Answers  

---

What are the types of sql commands?

0 Answers  

---

Mention what problem one might face while writing log information to a data-base table in pl/sql?

0 Answers  

---

How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')

2 Answers  

---

Can we join more than 2 tables in sql?

0 Answers  

---

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 Answers  

---

define sql

3 Answers   Zensar,

---

Can we create index on primary key?

0 Answers  

---