Re: Problem: data in a column of datatype 'long'
From: JamesF5088 <jamesf5088_at_aol.com>
Date: 30 Jul 1994 22:30:05 -0400
Message-ID: <31f2bd$j5l_at_search01.news.aol.com>
Date: 30 Jul 1994 22:30:05 -0400
Message-ID: <31f2bd$j5l_at_search01.news.aol.com>
In article <27JUL94.10290908_at_swdev.si.com>, dba_at_swdev.si.com (Tom Miheve) writes:
I've not tried this with data type long but maybe this will work:
In your pl/sql declare block declare a variable of type char and a cursor
to
select your column of type long. Fetch the cursor into the variable
and substr the variable. Hope this will work.
JIm
Received on Sun Jul 31 1994 - 04:30:05 CEST