I don't think so I have been using it since version 7.
Give it a try on your instance.
Happy hunting.
Scott.
"Chen, Gin"
<Gin_Chen@TVRATIN To: [EMAIL PROTECTED]
GS.COM> cc:
Sent by: A Subject: Re: Please help! Recursive
loop in JSP
mailing list
about Java Server
Pages
specification and
reference
<JSP-INTEREST@JAV
A.SUN.COM>
.
11/13/01 03:01 PM
Please respond to
A mailing list
about Java Server
Pages
specification and
reference
Thats pretty cool Scott. But its only available using Oracle 9i. :P
Heres a link to it for those too lazy to look it up :)
http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90125/qu
eries2.htm
-Tim
-----Original Message-----
From: Scott Watson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 13, 2001 2:51 PM
To: [EMAIL PROTECTED]
Subject: Re: Please help! Recursive loop in JSP
Joe,
You can get more information at otn.oracle.com or do a search on google.
I believe these type of queries are called Hierarchical Queries.
Your DBA should be able to provide you with more information.
The level pseudo column is what tells you how far from the root this record
can be found.
Scott.
Joe Cheng
<[EMAIL PROTECTED]> To:
[EMAIL PROTECTED]
Sent by: A cc:
mailing list Subject: Re: Please help!
Recursive loop in JSP
about Java Server
Pages
specification and
reference
<JSP-INTEREST@JAV
A.SUN.COM>
.
11/13/01 11:00 AM
Please respond to
A mailing list
about Java Server
Pages
specification and
reference
>> If you are selecting data from a database and that database happens to
be
Oracle look at the connect by clause. It does everything you are looking
for. <<
that's really interesting, I've never heard of "connect by". can you or
Ross provide more detail, i.e. what does the resulting recordset look like?
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
