View previous topic :: View next topic |
Author |
Message |
Beswar Beginner
Joined: 04 Feb 2003 Posts: 33 Topics: 15
|
Posted: Wed Mar 05, 2003 10:59 am Post subject: Regarding Cursors |
|
|
Hi
Can I fetch the records and also use one more query on the same table(i.e just selecting the records using the prmiary key). If I can, can I still fetch the records without lossing the data.
Thanks
Eswar |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12376 Topics: 75 Location: San Jose
|
Posted: Wed Mar 05, 2003 11:11 am Post subject: |
|
|
Beswar,
You can select and fetch on the same table as long as you are not selecting and fetching into the host variables of the table.
Hope this helps...
cheers
kolusu |
|
Back to top |
|
|
Beswar Beginner
Joined: 04 Feb 2003 Posts: 33 Topics: 15
|
Posted: Wed Mar 05, 2003 11:32 am Post subject: |
|
|
Thanks Kolusu, I will try this |
|
Back to top |
|
|
|
|