|
View previous topic :: View next topic
|
| Author |
Message |
anurag_25dec
New User
Joined: 01 Aug 2006
Posts: 4
Location: Banglore
|
|
|
|
| As Cursor is used to fetch Multiple rows and processing can be done now we can also retrive multiple rows by single select then what is the difference? |
|
| Back to top |
|
 |
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hi Anurag,
If the query return multiple rows then we need to use cursor to process every record i n resultset that cant be possible in using select in program. |
|
| Back to top |
|
|
prashanth1
New User
Joined: 27 Sep 2006
Posts: 47
Location: Hyderabad
|
|
|
|
As of my knowledge.
SQL : It performs a set level process. The reslut will be stored in a temporary table.
COBOL : Is a record level process. Means that it can process only one record at a time.
Pls correct me , if I wrong |
|
| Back to top |
|
|
|
|
