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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Convert LONG to a string

Re: Convert LONG to a string

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 17 May 2006 16:33:01 -0700
Message-ID: <1147908781.777589.228710@i40g2000cwc.googlegroups.com> 





 I do not have a system in front on me to test with but I am fairly
sure that the to_clob function will convert a long datatype to a clob
datatype then you can use dbms_lob functions on the column.



Neither the 9.2 or 10.2 SQL manual entries on to_clob list long as a
valid datatype to the function but it takes every other kind of
character data so it should work.



HTH  -- Mark D Powell --
Received on Wed May 17 2006 - 18:33:01 CDT












Original text of this message













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