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 packages are available to pl/sql developers?

613

What is the basic form of sql query?

501

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

557

What is crud sql?

559

What is difference between sql and oracle?

576

I need a function for a train ticket reservation please answer it thanks in advance

571

What are user defined functions?

588

How can triggers be used for the table auditing?

603

What is attribute indicator in pl sql?

539

What is the order of sql select?

583

What is difference between left and right outer join?

532

what is query cache in mysql? : Sql dba

585

How do we accept inputs from user during runtime?

561

Is id a reserved word in sql?

670

what is cross join? : Sql dba

581