| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
