Skip to Main Content
Forums

Oracle Database Discussions

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!

Column width increase in Oracle

User_19BPUJun 14 2017 — edited Jun 14 2017

Hi,

I want to increase the column width of a particular column from varchar2(250) to varchar2(350), whether we can directly go and make this change in Production without worrying about any data loss? I hope this wont have any impact on the existing data in the table?

alter table CUST_ADDRESS modify address varchar2(350);

Whether the above is the right way of doing it in Oracle 12c?

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 12 2017
Added on Jun 14 2017
#general-database-discussions
6 comments
2,980 views