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

Write a unique difference between a function and a stored procedure.

924

What is the meaning of disabling a trigger?

1110

how to rename an existing table in mysql? : Sql dba

1004

What is the unique index?

1002

How many scalar data types are supported in pl/sql?

975

How do sql databases work?

943

What is primary key and unique key?

1048

Why do we need databases?

984

Which table is left in join?

913

What is pl sql block in dbms?

948

What does sign mean sql?

1019

What is dense_rank?

879

Is it possible to sort a column using a column alias?

990

What are primary key and foreign key and how they work?

926

What is the difference between left and left outer join?

891