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

What is trigger in pl sql with examples?

What are pl sql procedures?

How to run sql statements through the web interface?

What is pl sql commands?

what command is used to create a table by copying the structure of another table including constraints ?

25.67,-1 Trunc = 20 Round= 30 HOW????

how to retrive only second row from table?

what is a database lock ? : Sql dba

what is the order of pre-defined exceptions.

What is meant by <> in sql?

Is microsoft sql free?

Are subqueries faster than joins?

For more SQL PLSQL Interview Questions Click Here