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 sql database should I use?

1123

What is delimiter sql?

966

What are sql data types?

998

Who developed sql?

1019

Is keyword pl sql?

962

what is the use of set statement in tsql? : Transact sql

993

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

981

Why are aggregate functions called so?

933

How do you bind variables in pl sql?

1075

What are packages in pl sql and also explain its advantages?

1015

What is compound trigger?

1016

Define sql delete statement.

988

Can we join more than 2 tables in sql?

1001

What is pivot table in sql?

1082

What is the difference between Union and Union all. Which is faster.

1382