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

How do I order by ascending in sql?

542

Is record in oracle pl sql?

535

What is the difference between in and between in sql?

578

How do I pipe the output of one isql to another?

534

Can we use join in subquery?

568

what is a view? : Sql dba

638

What is consistency?

717

How do you clear the screen in sql?

606

Are subqueries faster than joins?

577

what are the advantages and disadvantages of cascading style sheets? : Sql dba

555

What are different types of functions in sql?

512

Does user triggers have entry for trigger with compilation errors?

602

What does seeding a database mean?

531

What does select top 1 do in sql?

544

Are subqueries better than joins?

536