Interested to Buy Any Domain ? << Click Here >> for more details...
I have a table which has thousand of records i want to
fetch only record num 100 to record num 200. Write a query
that satisfies this criteria.(Cant use any keys)
Anyone please reply ASAP!
- 17 Answers
- 27218 Views
- KNIT, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / sudheer d
YA THE ANSWER IS BY USING CURSORS ONLY
declare
cursor USER_Cursor
is select *
from <table_name>;
y <TABLE_NAME>%ROWTYPE; --ITS A DATA TYPE INCLUDES
WHOLE ROW 4M A TABLE IN TO X
COUNT1 number(2);
begin
COUNT1:=1;
open USER_Cursor;
while USER_Cursor%FOUND AND COUNT1 <>101
loop
fetch USER_Cursor into y;-- JUST FETCH DONT DISPLY -
--TILL 101ST RECORD
COUNT1:=COUNT1+1;
end loop;
--NOW DISPLAY FROM 101 RECORD TO 200 RECORD
while USER_Cursor%FOUND AND COUNT1 <>201
loop
fetch USER_Cursor into y;
dbms_output.put_line(y);
COUNT1:=COUNT1+1;
end loop;
close USER_Cursor;
end;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to view db2 table structure?
List out the buffer pools in db2
What is bind package and plan in db2?
Explain about mirror activator disk mirroring?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is ibm db2 database?
How to access db2 tables in mainframe?
What are the uses of db2 optimizer?
What is the default page size of buffer pools?
What are the benefits of using the db2 database?
What is sqlca?
What is the physical storage length of time data type?
What is ibm db2 used for?
What is copy pending and check pending in db2?
What are iseries servers?
