Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> LONG datatype
I am spooling the results of a SQL*Plus query to a text file that is subsequently imported into a FileMaker Pro database. One of the columns is a LONG datatype. I am able to use the REPPLACE function on all columns except the LONG. This function is necessary in order to supress unwanted commas that may occur in the text returned by the query. Is there any easy way to convert the first thousand or two characters of a LONG to a Varchar2, then apply the REPLACE function? Thanks for any help as I'm new to SQL programming. -Ian
-------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to UsenetReceived on Mon Sep 29 1997 - 00:00:00 CDT