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!

changing data type on a field with populated data

476002May 17 2006 — edited May 17 2006

Hi
I have a table that has already been populated

i wish to change the data type of one of the fields from number to varchar2
this field has the same value you in it throughout
value = 2005 and i wish to change it to 2005/06

What is the best way to do this ?
thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 14 2006

Added on May 17 2006

4 comments

299 views