Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> 0ra-01002 error

0ra-01002 error

From: <spathiyal_at_yahoo.ca>
Date: 20 Jul 2005 08:00:37 -0700
Message-ID: <1121871637.259531.148160@g43g2000cwa.googlegroups.com> 





Hi there,


I am getting 0ra-01002 error when I will run the following query.
Could you please tell me how I can reolve this issue.



Thanks in advance,


S



 select level,id, childid , lpad(' ', 2*level- 1) || childid
  from table
  


   connect by prior childid=id
Received on Wed Jul 20 2005 - 10:00:37 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US