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 |
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
What is rename command in sql?
PL/SQL allocates memory for the variable's at runtime or at compile time
Why is sql important?
in a package one procedure is wrong package shows valid or not
What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?
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*/
What is Highwatermark?
What is cold data?
A table has 150 records. How do you retrieve 100th row to 120th row from that table ?
How many columns should be in an index?
What is sql performance tuning?