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 to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

998

what is the difference between myisam static and myisam dynamic? : Sql dba

1063

Which one is faster ienumerable or iqueryable?

932

when MSQL8.0 is in market

2076

what are the security recommendations while using mysql? : Sql dba

1116

what are the types of join and explain each? : Sql dba

1037

Does sql*plus have a pl/sql engine?

1069

What are field types?

1002

how do you login to mysql using unix shell? : Sql dba

1079

How exception is different from error?

1016

How is pl sql different from sql?

1086

what is meant by urlencode and urldocode? : Sql dba

1174

Why we use sql profiler?

956

Is a table valued function object?

1013

Can we use delete in merge statement?

1037