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 is before and after trigger?

691


What are hotfixes and patches?

691


How many types of keys are there in sql?

756


What is trigger and stored procedure in sql?

752


What is set transaction?

765






Is id a reserved word in sql?

860


How can you tell the difference between an index and a view?

690


Is hadoop a nosql?

745


I need a function for a train ticket reservation please answer it thanks in advance

760


How many types of primary keys are there?

710


Why use stored procedures?

774


Cite the differences between execution of triggers and stored procedures?

826


Is it possible for a table to have more than one foreign key?

774


What does the acronym acid stand for in database management?

775


How do you explain an index number?

746