Answer Posted / shekharjchandra
The basic structure of PL/SQL is
1. Header Section
2. Declaration Section
3. Executable Section
4. Exception Section
Eg:-
<<This_is_Header>>
DECLARE
a NUMBER ;
BEGIN
-- Code goes here
NULL;
EXCEPTION
WHEN OTHERS THEN
NULL ;
END ;
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Which function is used to return remainder in a division operator in sql?
what is the difference between clustered and non clustered index in sql? : Sql dba
what are the different type of sql's statements ? : Sql dba
what is the difference between a web-garden and a web-farm? : Sql dba
what is a constraint? Tell me about its various levels. : Sql dba
What are the parts of a sql statement?
What is the function that is used to transfer a pl/sql table log to a database table?
What is replication id?
what is the use of friend function? : Sql dba
What are sql indexes?
What is sql exception?
What is sp_helptext?
where are cookies actually stored on the hard disk? : Sql dba
Can we commit in trigger?
Define commit?