changing long col to varchar and vice versa

2001-08-16 Thread Schoen Volker
Hi list, I want to change col-types in one table. I have table T1 with two columns COL1 LONG and COL2 VARCHAR2(2000). Now I want to change the col-types vice versa, that means COL1 should be VARCHAR2(2000) and COL2 should be LONG. I have a lot of data in that cols, but all data is smaller than

Re: changing long col to varchar and vice versa

2001-08-16 Thread Galen Boyer
On Thu, 16 Aug 2001, [EMAIL PROTECTED] wrote: I want to change col-types in one table. I have table T1 with two columns COL1 LONG and COL2 VARCHAR2(2000). Now I want to change the col-types vice versa, that means COL1 should be VARCHAR2(2000) and COL2 should be LONG. I have a lot of data in

Re: changing long col to varchar and vice versa

2001-08-16 Thread DBarbour
v.schoen@inpl To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] an.de cc: Sent by: Subject: changing long col to varchar