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?
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.
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