Hi sorry my previous reply gives only 100th record if you need every 100th record the query for the same will be
select ename from (select rownum r,ename from employee1)
where mod(r,100)=0;
sushma
Last Activity: Apr 4 '10, 05:20 AM
Joined: Dec 13 '06
Location:
-
hi,
I am just giving an example.
Taking an employee1 table and retriving the 5th record in it. Hope it will help you.
SQL> select * from (select rownum RN,ename from employee1) where RN/5=1;
RN ENAME
---------- ----------
5 MARTIN
just give 100 instead of 5 to get 100th record.
in case of any issues let me know.
Regards
...Leave a comment:
-
hi,
SQL> SELECT 'ABC'|| CHR(10)||'DEF' as test from dual;
TEST
-------
ABC
DEF
It worked for me. try it out i think this is the right procedure.Leave a comment:
-
hi the solution for your problem is:
SQL> declare
2 present number(7,2):=10 24.00;
3 inc number(10,2);
4 final number(10,2);
5 mon number;
6 begin
7 final:=1024.00;
8 mon := months_between( to_date('may-06','mon-yy'),to_date('j une-05','mon-yy'));
9 for i in 1..mon loop
10 present...Leave a comment:
No activity results to display
Leave a comment: