Re: cursor on long data tables
Date: Thu, 7 Feb 2002 16:14:37 +0900
Message-ID: <a3t92i$sf8$1_at_donald.i.coe.nttdata.co.jp>
Have you checked on "ROWNUM"?
select row_nm, empno, ename
from (
select rownum row_nm, empno, ename from emp
)
where mod(row_nm,10)=0;
viel Glueck,
kazuhiro
"Andreas Krämer Flecken" <a.kraemer-flecken_at_fz-juelich.de> wrote in message
news:3C600E61.6090903_at_fz-juelich.de...
> Hello,
>
> I have a table filled with data from an experiment. Now I like to
> retrieve the data by declaring a cursor on the table. The cursor fetchs
> all data. But I like to have only every tenth value or so. Do somebody
> know a way to program a cursor in that way that it fetches only every
> 10th row?
>
> Thanks a lot for advice or help.
>
> Andreas Kraemer-Flecken.
>
> --
> -------------------------------------------------------------------------
> *A.Krämer-Flecken Tel.: +49 2461 614521
> *Institut für Plasmaphysik FAX : +49 2461 615452
> *Forschungszentrum Jülich GmbH email:a.kraemer-flecken_at_fz-juelich.de
> *52425 Jülich flecken_at_eifel-net.net
> *GERMANY
> -------------------------------------------------------------------------
>
Received on Thu Feb 07 2002 - 08:14:37 CET