Answer Posted / vaibhavi_dixit

When an exception is raised, oracle searches for the
handler in the PL/SQL block, if not then the exception is
propagated to the outer block.If the outer block handles
the exception, then the statments are commited (i.e 1 & 2),
the error message will be displayed and the control will
return to calling environment.
If the exception remains unhandled in all blocks ,then
before control returning to the calling environment,
statements i.e (1 & 2) will be rolled back.

VD

How can you get sql*loader to commit only at the end of the load file? : aql loader

1059

---

What are string functions in sql?

1303

---

What is cursor in pl sql?

1185

---

What's the procedure?

982

---

What are secondary keys?

1030

---

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

2602

---

What is a primary key? Explain

1023

---

What is consistency?

1187

---

does sql support programming? : Sql dba

1087

---

What is cte?

1020

---

what is a constraint? Tell me about its various levels. : Sql dba

1047

---

How do I get sql certification?

1017

---

what is a trigger in mysql? : Sql dba

1214

---

What is the use of %rowtype?

1086

---

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

1006

---