What are the components of a PL/SQL block ?

Answer Posted / nishi

Declare section

---

declaring the variables

---

Begin section

---

executable statements

---

Exception section

---

exception handlers

---

end;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does select * from mean in sql?

1983


How can I get the number of records affected by a stored procedure?

569


What is the execution plan in sql?

554


What is offset in sql query?

593


How many sql statements are used? Define them.

571






How do you select unique values in sql?

494


What is the difference between function, procedure and package in pl/sql?

556


In pl/sql, what is bulk binding, and when/how would it help performance?

527


What are the basic sql commands?

544


Is sql a programming?

542


What is a table in a database?

573


how to write date and time literals? : Sql dba

528


Which join condition can be specified using on clause?

512


Which command is used to delete a trigger?

768


What are pl/sql packages?

567