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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
