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 are local and global variables and their differences?

1134

What does an inner join do?

1248

Can sql function call stored procedure?

1070

Why is theta join required?

1185

How do you remove duplicate records from a table?

976

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

1078

What are the different types of tables in sql?

1062

Is the primary key an index?

1073

List the different type of joins?

1113

Is left join faster than inner join?

1166

What is the use of count (*) in sql?

1113

Does sap use sql?

1038

What is the difference between nvl function, ifnull function, and isnull function?

1151

Why truncate is used in sql?

1041

Explain how exception handling is done in advance pl/sql?

1043