Re: copying to a smaller column

Richard Baines <richardbaines_at_netscape.net> writes:

> I have a table containing two varchar2 columns, one of size 500 and one
> of size 100.
> Is there a way of copying the first 100 characters of the 500 column to
> the 100 column.

Try the following:

UPDATE table_x SET target_column = SUBSTR(source_column, 1, 100);

Greetings,

Thomas Received on Mon Jun 21 1999 - 11:40:52 CDT