Home » RDBMS Server » Server Administration » copy remarks(1024) to remarks(255)
copy remarks(1024) to remarks(255) [message #370492] Mon, 06 December 1999 06:21
Ooiewe
Messages: 3
Registered: December 1999
Junior Member
Hi,

A simple sql statement will do, how do i copy a field of remarks varchar2(1024) to another field in another table declared as remarks varchar2(255)?

insert into dest ( select * from source);
ERROR at line 1:
ORA-01401: inserted value too large for column

what is the command to display the max length remarks, and what is the command to trim the data?

Thanks in advance.

Regards
Ooiewe
Previous Topic: CLOB to VARCHAR2
Next Topic: need help with dynamic sql.
Goto Forum:
  


Current Time: Tue Oct 20 09:27:46 CDT 2020