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
- 26480 Views
- KNIT, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / om prakash yadav
Note= Before i given the query it is worng pleas ignopre it.
Thanks.
========================================
using cursors you can do>
CURSOR Crs_trs IS
SELECT empno, empname, sal, deptno from emp WHERE empno
between 100 and 200;
vr_empno.empno%type;
vr_empname.empname%type;
vr_sal.sal%type;
vr_deptno.deptno%type;
BEGIN
OPEN Crs_trs;
IF crs_trs%ISOPEN THEN
LOOP
FETCH Crs_trs INTO vr_empno, vr_empname, vr_sal, vr_deptno;
dbms_output.put_line('empno__'||vr_empno );
dbms_output.put_line('empname__'||vr_empname);
dbms_output.put_line('empsalary__'||vr_empsal );
dbms_output.put_line('empdeptno__'|| vr_deptno);
EXIT WHEN Crs_trs%NOTFOUND;
END IF;
END LOOP;
CLOSE Crs_trs;
END;
| Is This Answer Correct ? | 1 Yes | 9 No |
Post New Answer View All Answers
How to execute stored procedure in db2 command editor?
What are the various isolation levels possible?
What are the two types of logging in the db2 database? Explain them.
Can we delete records from view?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What does db2 plan contain?
What is the meaning concurrency in the db2 database?
What is db2 look?
What is check constraint in db2?
What is query_cache_limit?
Which component is responsible for db2 startup and shutdown?
What is the latest version of ibm db2?
What is null indicator in db2?
what is the role of the cursor in db2?
Explain the contention situations caused by locks?
