srinadh

• Sep 9th, 2006

 

in stored procedure & function we can retrive the data sequentially we use cursor

krishnaindia2007

 Profile Answers by krishnaindia2007 

• Jun 22nd, 2008

 

>>what purpose we are using cursors? why you need cursor?
Whenever we are processing sql statement oracle allots PRIVATE SQL AREA OR WORK AREA to store porcessed information. Cursor is a pointer to this private sql area.
Oracle automatically creates an implicit cursor for each sql statement.
If you want to handle and control processing of each row of data explicitly you may define explicit cursor.
>> why i write into clause when i want to write select statement.
We can't access table data directly in pl/sql. First we have to bring it into some memory variable. Then we can access data using that variable name.
Select into is used to bring table data into memory variable.
 
>>when you are using out and inout paramaters mode in procedure......pls explain ...
Out is used to return value to the calling program.
IN OUT can be used to pass intial value to and retun a value to the calling environment.