What is the basic structure of PL/SQL ?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / guest

6 Answers
9955 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the basic structure of PL/SQL ?..

Answer / rajesh

Declare
begin
exception
end;

Is This Answer Correct ?

14 Yes

1 No

What is the basic structure of PL/SQL ?..

Answer / vasan

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

Is This Answer Correct ?

8 Yes

0 No

What is the basic structure of PL/SQL ?..

Answer / dinesh mishra

Header (named module only)
Declaration (IS)
Execution (BEGIN)
Exception
END;

Is This Answer Correct ?

6 Yes

0 No

What is the basic structure of PL/SQL ?..

Answer / menan

declaration part;
begin
executable part;
exception handling;
end;

Is This Answer Correct ?

5 Yes

0 No

What is the basic structure of PL/SQL ?..

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

What is the basic structure of PL/SQL ?..

Answer / kannan

# 4

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

Is This Answer Correct ?

0 Yes

2 No

Post New Answer