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 -> SYS_CONNECT_BY_PATH

SYS_CONNECT_BY_PATH

From: Arfan <Arfaan_at_gmail.com>
Date: 18 Jul 2006 03:12:12 -0700
Message-ID: <1153217532.555272.274080@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
Received on Tue Jul 18 2006 - 05:12:12 CDT












Original text of this message













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