Answer / rajesh

Declare
begin
exception
end;

Answer / vasan

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

Answer / dinesh mishra

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

Answer / menan

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

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 ;

Answer / kannan

# 4

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

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;

10 Answers  

Explain what is a column in a table?

0 Answers  

What are pl/sql packages?

0 Answers  

What is a constraint. Types of constraints ?

5 Answers   Accenture, BirlaSoft,

Can a varchar be a primary key?

0 Answers  

What is insert command in sql?

0 Answers  

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

0 Answers  

What are the string functions in sql?

0 Answers  

Which are sql * plus commands?

0 Answers  

How to recompile a already made trigger?

2 Answers  

need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

1 Answers  

Can a key be both primary and foreign?

0 Answers