Home » RDBMS Server » Server Administration » CLOB to VARCHAR2
CLOB to VARCHAR2 [message #370489] Fri, 03 December 1999 13:16
AT
Messages: 14
Registered: July 1999
Junior Member
How can I do this conversion? I have:

create table t1 (x clob);
create table t2 (y varchar2(4000));
insert into t1 values ('test row');
insert into t2 select * from t1;
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ gives ORA932 (inconsistent datatypes).

Any ideas? Thanks in advance,
-AT
Previous Topic: Using variables for record groups
Next Topic: copy remarks(1024) to remarks(255)
Goto Forum:
  


Current Time: Thu Mar 28 14:33:10 CDT 2024