|
View previous topic :: View next topic
|
| Author |
Message |
sant532
New User
Joined: 02 Jun 2008
Posts: 48
Location: India
|
|
|
|
I need to fetch information from a table using one cursor.
let wh-num=10
and the Cursor is:
select name
from maintb
where num = :wh-num
In the maintb we have 3 rows for wh-num=10
how to fetch all the 3 rows?
In EZT we need to close the cursor for every fetch I think. |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| In EZT we need to close the cursor for every fetch I think. |
Why do you think this? |
|
| Back to top |
|
|
|
|
