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

Is trigger a stored procedure?

739


What is type and rowtype in pl sql?

792


Can we use threading in pl/sql?

757


What is difference sql and mysql?

748


how to present a past time in hours, minutes and seconds? : Sql dba

781


What is the use of sqlerrd 3?

727


How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1002


What is Materialized View? In What Scenario we Use Materialized View?

9027


How do I run a sql query?

786


what is a database? : Sql dba

852


What is compiled query?

780


What is tuple in sql?

780


How exception handling is done in advance pl/sql?

710


What is sqlerrm?

742


What are the properties of a transaction?

868