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

What is record type in pl sql?

933

What are the sql aggregate functions?

1065

Why plvtab is considered as the easiest way to access the pl/sql table?

1129

what are null values? : Sql dba

899

How many types of relationship are there?

973

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1155

what is try_catch block in procedure

1655

Can we alter stored procedure?

942

What is before trigger?

945

Explain the difference between triggers and constraints?

919

What is the difference between a query and a report?

900

What is difference between pl and sql?

992

What is materialized view. What are different methods of refresh?

1329

How do you declare a variable in pl sql?

964

Is sql pronounced sequel or sql?

1212