10 Replies Latest reply: Mar 19, 2012 2:23 AM by 924756 RSS

    how to change the column datatype to number from varchar2 in oracle10g

    612739
      hi i created one table in oracle 10g in that table i took one column data type as varchar2
      ex:desc user;
      Name Null? Type
      ----------------------------------------- -------- ----------------------------
      USERID NOT NULL VARCHAR2(5)
      FIRSTNAME NOT NULL VARCHAR2(15)
      LASTNAME VARCHAR2(15)
      EMPID VARCHAR2(5)
      USERNAME VARCHAR2(20)
      PASSWORD NOT NULL VARCHAR2(20)
      MOBILE NUMBER(12)
      EMAILID VARCHAR2(20)

      but i don't want to take userid as varchar i want to change it as number
      for this i tried with alter statement like:
      alter table user modify(UserId number(5));
      but i'm getting this error:
      column type incompatible with referenced column type
      how to resolve this one, here i'm using oracle 10g rl2