Give the structure of the procedure ?

Question Posted / guest

Give the structure of the procedure ?..

Answer / tulsi

PROCEDURE name (parameter list.....)
is
local variable declarations

BEGIN
Executable statements.
Exception.
exception handlers

end;

Is This Answer Correct ?

2 Yes

1 No

More SQL PLSQL Interview Questions

Can there be more than one function with a similar name in a pl/sql block?

Does oracle roll back the transaction on an error?

How do you bind variables in pl sql?

Explain foreign key in sql?

I have 2 Databases. How can create a table in particular database? How can i know the list of tables presented each database?( in oracle 10g)

What is a cursor ? Why Cursor is required ?

Can you load data into multiple tables at once? : aql loader

What is output spooling in sql*plus?

What do you mean by stored procedures? How do we use it?

what is definer rights invoke rights?

What is the difference between count 1 and count (*) in a sql query?

What is compilation error in pl sql?

For more SQL PLSQL Interview Questions Click Here