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
Explain the the update statement in sql?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
How to Execute a Package in PL/SQL.?
what is sub-query? : Transact sql
What is fmtonly in sql?
What is an escape character in sql?
What is nosql example?
What is rownum and rowid?
What is a natural join?
What is pivot query?
What is a trigger in sql?
what is the difference between a web-garden and a web-farm? : Sql dba
What is procedure explain with program?
What is orm in sql?
What is the clause we need to add in function body to return variable?