Re: SYS_CONNECT_BY_PATH

Arfan wrote:
>
> 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

Try
(1) a very uncommon character such as backtick (`) or (2) more than one character such as <->, or &#151; or (3) use a character outside of ASCII

If you do mean the text can have any character, option (2) is the best. Theoretically, a monkey can type a whole book by Shakespeare by jumping on the typewriter. But in reality, it won't happen.

Yong Huang Received on Tue Jul 18 2006 - 11:43:54 CDT