Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: LONG datatype
ianj_at_gene.com wrote:
>
> 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 UsenetLong datatypes cannot be formatted within a select statement. The only
thing you can do is include them in the select portion of the select
statement. - Sorry
-Sheilah Scheurich
DBA
to respond via email remove the underscores.
Received on Tue Sep 30 1997 - 00:00:00 CDT