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
Messages: 3
Registered: December 1999
Junior Member

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.

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

Current Time: Tue Dec 06 19:09:47 CST 2022