Procedure specification: create or replace procedure proc-nm (agumentlist)

What are the two parts of a procedure ?

Question Posted / a.jyothsna

Answer Posted / a.jyothsna

Procedure specification: create or replace procedure proc-nm
(agumentlist)
procedure body: is-------------end

Is This Answer Correct ?

2 Yes

5 No

Please Help Members By Posting Answers For Below Questions

How many sql commands are there?

1102

what is the stuff function and how does it differ from the replace function? : Sql dba

1027

Which one is better subquery or joins?

1039

what is a database? : Sql dba

1140

What is embedded sql in db2?

992

What is faster join or subquery?

994

give the syntax of grant and revoke commands? : Sql dba

1134

What is the use of nvl function?

1174

discuss about myisam key cache. : Sql dba

1004

Describe sql comments?

1010

which types of join is used in sql widely? : Sql dba

966

Is it possible to pass parameters to triggers?

1081

What is normalisation in sql?

1040

What is the difference between a query and a report?

948

What is self-join and what is the requirement of self-join?

1130