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

difference between SQL and C

what are the 'mysql' command line options? : Sql dba

what is a trigger? : Sql dba

What has stored procedures in sql and how we can use it?

What is autocommit sql?

Is it possible to read/write files to-and-from PL/SQL?

What is difference between joins and union?

what are the differences between char and nchar? : Sql dba

How does postgresql compare to mysql?

Is sql between inclusive?

Talk about views

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

For more SQL PLSQL Interview Questions Click Here