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 is user defined functions? : Sql dba

775


Is json a nosql?

747


Can we join 3 tables in sql?

726


what is the difference between sql and t-sql? : Transact sql

832


Is there a way to automate sql execution from the command-line, batch job or shell script?

763


what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

730


What does over partition by mean in sql?

721


What are the different dcl commands in sql?

793


Can we create table in function?

746


what is auto increment? : Sql dba

777


Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

758


Is left join inner or outer by default?

780


What is sql and also describe types of sql statements?

778


what is normalization? : Sql dba

760


Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

820