Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: CONNECT BY Questions...
Jimmy wrote:
> I find that using CONNECT BY is not an easy job. Could anyone suggests
> me the books on teaching how to use CONNECT BY? Is CONNECT BY only used
> in Oracle? Not SQL standard?
>
I don't think it's SQL standard, but I'm not sure...
Have you tried adding an Order by clause ?
In general, the output order of an SQL statement (in Oracle) is not
guaranteed without an order by clause. It is usually the order in which
the rows were entered, but this is not a rule. Try an order by and I think
you got what you need.
--
Posted via CNET Help.com
http://www.help.com/
Received on Sat Oct 16 1999 - 04:00:38 CDT