PROCEDURE name (parameter list.....) is local variable declarations BE

Give the structure of the procedure ?

Question Posted / tulsi

Answer Posted / tulsi

PROCEDURE name (parameter list.....)
is
local variable declarations

BEGIN
Executable statements.
Exception.
exception handlers

end;

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is trigger price?

731

What is %rowtype in pl sql?

685

Can there be more than one function with a similar name in a pl/sql block?

746

What is the starting oracle error number? What is meant by forward declaration in functions?

738

Explain the commit statement.

848

define sql delete statement ? : Sql dba

745

How sql query is executed?

782

what is rollback? : Sql dba

757

What is difference between table and view?

706

What is sql not null constraint?

775

Explain the significance of the & and && operators in pl sql.

748

What is pragma in sql?

817

What is embedded sql what are its advantages?

691

Is join and inner join the same?

724

How are sql commands classified?

801