Skip to Main Content
Forums

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!

How to change the datatype in the oracle table?

711010Jul 29 2009 — edited Jul 30 2009
Hi,

I need to change the datatype of the column in Oracle table. That column contains some data. I do not want to loose those data.

For altering a table/column condition are:

1. either table should not contain any data.
2. either that column should not contain any data.

Please suggest how i can handle this situation.

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 27 2009
Added on Jul 29 2009
5 comments
950 views