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

Home -> Community -> Usenet -> c.d.o.server -> Re: SYS_CONNECT_BY_PATH

Re: SYS_CONNECT_BY_PATH

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 18 Jul 2006 18:44:14 +0200
Message-ID: <44bd0fde$0$29939$626a54ce@news.free.fr>

"Arfan" <Arfaan_at_gmail.com> a écrit dans le message de news: 1153217532.555272.274080_at_h48g2000cwc.googlegroups.com...
| hi,
|
| I am currently using SYS_CONNECT_BY_PATH to get the complete root path
| of a database field. Now the problem is that the separator i m using
| for it is "-" (dash), but this character can also be a part of the data
| of that field. Therefore it says "cannot have separator as part of
| column". Actually this field can have any character, therefore suggest
| me any alternative method for it.
|
| Regards,
| Arfan
|

Use another character and then replace it with the one you want.

Regards
Michel Cadot Received on Tue Jul 18 2006 - 11:44:14 CDT

Original text of this message

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