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

i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.

What is the clause we need to add in function body to return variable?

What is the difference between clustered and non-clustered indexes?

How to load data with sql*loader?

How do I get sql certification?

Is subquery faster than join?

Is pl sql a scripting language?

Does google use sql?

How do you retrieve the second highest salary from a table?

what is the difference between join and union? : Sql dba

What is an invalid partition table?

A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.

For more SQL PLSQL Interview Questions Click Here