oracle 8.0 bugs

[webfrancy]

SELECT * FROM (
  SELECT * FROM (
    SELECT c_rrn
    FROM (
      SELECT * FROM gvsa.tgvs32_tra, gvsa.tgvs30_esi_tra, gvsa.tgvs31_esi_val, gvsa.tgvs33_soc
      WHERE d_ora_arr >= TO_DATE('11062003200000', 'DDMMYYYYHH24MISS')
      AND d_ora_arr <= TO_DATE('11062003235959', 'DDMMYYYYHH24MISS')
      AND gvsa.tgvs30_esi_tra.c_esi_tra=gvsa.tgvs32_tra.c_esi_tra
      AND gvsa.tgvs31_esi_val.c_esi_val=gvsa.tgvs32_tra.c_esi_val
      AND gvsa.tgvs33_soc.c_soc=gvsa.tgvs32_tra.c_soc
      ORDER BY c_rrn
    )
  )
  WHERE ROWNUM <= 10
) ORDER BY c_rrn

I have some problems with this query.. can u help me?
in Oracle 8.0 it returns no data

[skhanal]

Do you get anything when you run the inner most select?

If you get any rows, then add next level of select and so on. I am not sure whether there is a limitation on a number of layer you can have.