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

What is the basic structure of PL/SQL ?

Question Posted / menan

Answer Posted / menan

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

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

difference between anonymous blocks and sub-programs.

1188

What is the default isolation level in sql server? : Transact sql

1080

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1131

How to run sql*plus commands in sql developer?

1206

What is the difference between clustered and non-clustered index in sql?

1065

How do I find duplicates in sql?

980

how to return query output in html format? : Sql dba

1121

Does sql require a server?

1055

How do I view tables in sql developer?

1009

What does the file extension accdb stand for?

1015

What is orm in sql?

1099

What is the difference between the sql*loader and import utilities? : aql loader

1090

Which query operators in sql is used for pattern matching?

1009

How do I create a memory optimized filegroup?

1012

Is it possible for a table to have more than one foreign key?

1080