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

How do you know if a relationship is 2nf?

518


What is sql profiler in oracle?

564


What is faster join or subquery?

512


what is a primary key? : Sql dba

554


what is the difference between rownum pseudo column and row_number() function? : Sql dba

618






what is a stored procedure? : Sql dba

555


Is mariadb a nosql database?

540


Explain constraints in sql?

573


Which one is faster ienumerable or iqueryable?

487


What is the difference between unique and primary key constraints?

588


how to use case expression? : Sql dba

551


How do sql databases work?

531


Can we join two tables without common column?

514


What version is sql?

553


what is a cursor? : Sql dba

557