RE: QUERY HELP

[Daemen, Remco]

Title: QUERY HELP

Do you want a query to return the missing numbers, or do you want a query to return the records AFTER some numbers have been skipped ?

 

The first can be done in pl/sql (loop with counter compared to rownum), the latter in sql (use "where not exists ...").

 

HTH,  Remco

-----Oorspronkelijk bericht-----
Van: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL PROTECTED]]
Verzonden: dinsdag 26 juni 2001 15:01
Aan: Multiple recipients of list ORACLE-L
Onderwerp: QUERY HELP

Dear Guru's,

How can i refer the previous record detail(s), when oracle fetchs the current row details?.

sql> SELECT rownum rnum, empno eno, ename FROM EMP;

RNUM    ENO     ENAME
----------------------------------
1       7369    SMITH
2       7499    ALLEN
3       7521    WARD
4       7566    JONES
7       7782    CLARK
8       7788    SCOTT
10      7844    TURNER

In the above, can i able to put * mark in record 7 and 10, since before these two records, some records are missing.

Is this possible to do this by query. I need this in reports.

Basically my question is,
How can i refer the previous row detail(s), when oracle fetchs the current row details?.

Thanks in adv.

REgards,
Nirmal.