Re: Populating VARCHAR2 with LONG data...

You can not do this with SQL. You must use a procedural language such as PL/SQL.

If your long columns are > 32k, PL/SQL will not work either. You will have to use C or Java (not sure about Java and Longs) , or some other supported procedural language.

Jared

On Monday 31 March 2003 07:08, Gujral, Harpal S. wrote:
> Hello Guys,
>
> We have a requirement to add a VARCHAR2 column to an existing table which
> is a part of an application and also has a LONG column with data in it.
> Without using PL/SQL, how can we create the new VARCHAR2 column and
> "default" it to the LONG column data?
>
> The idea is all future inserts and updates made to the LONG column by the
> application, should get reflected in the VARCHAR2 column. We need to use
> this new VARCHAR2 column for reporting and use a WHERE clause on the column
> to filter data.
>
> Any help would be greatly appreciated.
>
> Thanks
> Harpal

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).