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

Report message to a moderator

Previous Topic: Using variables for record groups
Next Topic: copy remarks(1024) to remarks(255)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Oct 01 22:03:51 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.