Re: How to convert LONG to VARCHAR2????
From: Sean P Murphy <spm03_at_gnofn.org>
Date: 19 Feb 2000 05:46:08 GMT
Message-ID: <88lan0$1f0d$2_at_junkie.gnofn.org>
> > How can I convert a LONG to VARCHAR2 data,
> > so I can use standard string functions (SUBSTR,etc)
> > on it?
Received on Sat Feb 19 2000 - 06:46:08 CET
Date: 19 Feb 2000 05:46:08 GMT
Message-ID: <88lan0$1f0d$2_at_junkie.gnofn.org>
In comp.databases.oracle.tools Martin Friemann <m.friemann_at_eai-delta.de> wrote:
Long fields are a special bunch. I did not have any trouble with the
substr function though. This is what I had to do:
For I in 1..10
text_io.putline substr(comments,I,250);
I = I + 250;
Loop;
Do not quote me on the syntax, but I was successsful with substr...
Sean
> Manuel Dias wrote:
> > How can I convert a LONG to VARCHAR2 data,
> > so I can use standard string functions (SUBSTR,etc)
> > on it?
Received on Sat Feb 19 2000 - 06:46:08 CET