GurcanK
asked on
How to do Insert Into/Select with CLOB Columns?
Dear Experts,
Could you confirm whether below SQL is valid or not, or could you please offer me an alternative?
Table TA (x number, y number, z clob)
Table TB (a number, b number, c varchar, d varchar, e varchar)
insert into TA (x,y,z,) select a, b, to_clob(concat(concat(c,d) ,e)) from TB;
BR
Could you confirm whether below SQL is valid or not, or could you please offer me an alternative?
Table TA (x number, y number, z clob)
Table TB (a number, b number, c varchar, d varchar, e varchar)
insert into TA (x,y,z,) select a, b, to_clob(concat(concat(c,d)
BR
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I think you mean implicit conversion.
>>What happens if I put to_clob?
Nothing.
>>Table TB has no CLOB fields.
So? You are inserting varchar2 objects into a CLOB field. That is just fine.
Nothing.
>>Table TB has no CLOB fields.
So? You are inserting varchar2 objects into a CLOB field. That is just fine.
ASKER