What are the components of a PL/SQL block ?

Answer Posted / a.jyothsna

Declare section
---
declaring the variables
---
Begin section
---
executable statements
---
Exception section
---
exception handlers
---
end;

Is This Answer Correct ?    10 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is natural join and inner join same?

697


Explain unique key in sql.

774


what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

762


What is multiple partition?

730


Why do we need databases?

770


How many sql databases can you have on one server?

806


Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

925


how is myisam table stored? : Sql dba

819


What is nosql example?

819


Can we rollback delete command?

747


How do I install sql?

730


What programs use sql?

775


What is sap sql anywhere?

716


What are the disadvantages of not performing database normalization?

850


Explain the structure of pl/sql in brief.

833