What is the basic structure of PL/SQL ?
Answers were Sorted based on User's Feedback
Answer / vasan
Declare (Optional)
begin (Mandatory)
exception(Optional)
end; (Mandatory)
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / dinesh mishra
Header (named module only)
Declaration (IS)
Execution (BEGIN)
Exception
END;
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / menan
declaration part;
begin
executable part;
exception handling;
end;
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
Answer / kannan
# 4
Declare (Optional)
begin (Mandatory)
exception(Optional)
end; (Mandatory)
Is This Answer Correct ? | 0 Yes | 2 No |
Give which cursor is better for better performance means type of cursors?
What does the acronym acid stand for in database management?
What is not equal in sql?
Which is faster joins or subqueries?
How can multiply values of a column? OR How can multiply value of a row of a column using a single query in SQL?
What is data control language (dcl)?
Is there any restriction on the use of union in embedded sql?
Can you have a foreign key without a primary key?
what is the difference between granting and creating a view?
what is the difference between join and union? : Sql dba
How many types of triggers exist in pl/sql?
Which sql statement is used to return only different values?