| November 11, 2008 21:38:25 |
#2 |
| kz4ora |
Member Since: October 2008 Total Comments: 2 |
RE: Explicit cursor and Select into statement
|
Explicit cursor- They are defined by programmer.
The select statement can return multiple rows as a query result. If you want to process single row at a time then you can define an explicit cursor for this select statement.
Cursor is like a temporary area where you can process fetch the records and process then individually as required
select into statement-
select value1,value2... into var1,var2...... |
| |
