Give the structure of the procedure ?



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

Post New Answer

More SQL PLSQL Interview Questions

hi..........i m Accenture employee...Accenture is an IT company having itz branches in India at Mumbai, Pune,Delhi, Hyderabad, Chennai and Bangalore....Presently there are openings here for SAP, Testing, Oracle,Java,.NET,MAinframe and Peoplesoft...... I am a software engineer working with Accenture,Mumbai....u can mail me in your resume..i`ll forward it to our HR team...my mail id: pankit.lodaya@accenture.com

8 Answers   Wipro,


What is rename command in sql?

0 Answers  


PL/SQL allocates memory for the variable's at runtime or at compile time

3 Answers  


Why is sql important?

0 Answers  


in a package one procedure is wrong package shows valid or not

4 Answers  






What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?

6 Answers   Saama Tech,


write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,


What is Highwatermark?

3 Answers   Thermotech,


What is cold data?

0 Answers  


A table has 150 records. How do you retrieve 100th row to 120th row from that table ?

21 Answers   IBM,


How many columns should be in an index?

0 Answers  


What is sql performance tuning?

0 Answers  


Categories