Oracle PL-SQL Question:
Download Questions PDF

Give the structure of the procedure?

Answer:

PROCEDURE name (parameter list.....)
is
local variable declarations
BEGIN
Executable statements.
Exception.
exception handlers
end;

Download Oracle PL-SQL Interview Questions And Answers PDF

Previous QuestionNext Question
What are the two parts of a procedure?Give the structure of the function?