|
View previous topic :: View next topic
|
| Author |
Message |
Nileshkul
New User
Joined: 09 May 2016
Posts: 43
Location: India
|
|
|
|
Help with a query please.
Planning to use multirow fetch in online screen. So have a query : does use of 'FOR FETCH ONLY' or 'FOR READ ONLY' allowed on multi row fetch cursor? Is it useful, benefecial to mention FOR FETCH on multi row fetch cursor? |
|
| Back to top |
|
 |
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3053
Location: NYC,USA
|
|
|
|
| Do you have manuals ? If not then look at the top part of this forum and then look what's the clause. This time I found for you, look here and there is no harm writing a simple program and test yourself or ask DBA. |
|
| Back to top |
|
|
Nileshkul
New User
Joined: 09 May 2016
Posts: 43
Location: India
|
|
|
|
My question was specific to multi row fetch cursor, planning to read 100 rows in single fetch
Thanks - will check manual for multi row fetch & sorry if I was not clear |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3053
Location: NYC,USA
|
|
|
|
| Why do you think the Read Only clause differs for multi row fetch without reading manuals? |
|
| Back to top |
|
|
|
|
