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

What are stored procedures used for?

759


What is dynamic sql in pl sql?

728


Can pl sql procedure have a return statement?

752


How do sql databases work?

743


What is a table?

754


Can we insert data in view?

708


What is sql indexing?

772


What is update query?

735


what is schema? : Sql dba

768


What is the most important ddl statements in sql are?

752


how do you login to mysql using unix shell? : Sql dba

768


What is a Mapplet?

834


If the application is running very slow? At what points you need to go about the database in order to improve the performance?

777


What is mutating sql table?

845


how to include comments in sql statements? : Sql dba

756