Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: SYS_CONNECT_BY_PATH
"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
![]() |
![]() |