SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reduce the length of varchar2 column by protecting data

484376Feb 3 2009 — edited Feb 3 2009

Hi,

I have a table in production and one of the column is having varchar2(12) nullable.Now the column datatype is going to change into varchar2(9).
How can i change the datatype of the column by protecting the data of that table.

Can anyone explain me what is the best way to deliver the sql script.

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 3 2009

Added on Feb 3 2009

2 comments

964 views