Hi all.
Can you help me with this problem :
I have the "Book" table with "title" and "Numeration" :
Book Numeration
"USA History" 4
"USA Sport History" 4.1
"USA swimming History" 4.1.2
"NATO" 9
"NATO History" 9.1
"NATO History Chairman" 9.2
and i need get as output this string : "USA History>USA Sport
History>"USA swimming
History"
"NATO">"NATO
History">"NATO History Chairman"
I can do this with a simple PLSQL program, but the problem is that my
customer requires a query to do this.
Its possible do this with the recursive conecept ?
Something like this(the following query dont work well) :
select CONNECT_BY_ROOT Numeration
from Book
where 1=1
START WITH (Numeration not like '%.%' )
CONNECT BY PRIOR Numeration ||'.%' = Numeration
Thanks,
Paulito Santana
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
