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 |
What are the two parts of a procedure ?
Explain the difference between 'between' & 'and' operators in sql
how can we find the number of rows in a table using mysql? : Sql dba
What is a system versioned table?
What is equi join in sql?
I need a function for a train ticket reservation please answer it thanks in advance
What is a unique key?
What is the Query to print out the individual total number of duplicate row in sql.
What are the types of records?
what are the nonstandard string types? : Sql dba
What is t-sql? : Transact sql
Types of cursors and explanation each of them ?