What is the basic structure of PL/SQL ?

Answer Posted / vasan

Declare (Optional)
begin (Mandatory)
exception(Optional)
end; (Mandatory)

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you delete duplicates in sql query using rowid?

720


Can there be more than one function with a similar name in a pl/sql block?

748


what are the different type of normalization? : Sql dba

765


What is the purpose of a sql?

688


What is the difference between view and stored procedure?

690






how to extract a unit value from a date and time? : Sql dba

732


what are local and global variables and their differences? : Sql dba

714


How to read/write files from pl/sql?

772


Which kind of parameters cannot have a default value in pl sql?

806


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

760


What is int identity in sql?

758


What are basic techniques of indexing?

1071


Is json a nosql?

723


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

790


What will you get by the cursor attribute sql%notfound?

779