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 can i modify table field from char to varchar

Tony007May 8 2013 — edited May 9 2013
hi i what to modify my table column from char to varchar2
SQL> ALTER TABLE CFG_OFFICE
MODIFY(OFFICECODE VARCHAR2(5 BYTE))
ALTER TABLE CFG_OFFICE
MODIFY(OFFICECODE VARCHAR2(5 BYTE))
Error at line 3
ORA-02267: column type incompatible with referenced column type
Edited by: adf009 on 2013/05/08 5:18 PM

Edited by: adf009 on 2013/05/08 5:19 PM
This post has been answered by John Stegeman on May 9 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 6 2013
Added on May 8 2013
#sql
10 comments
13,197 views