#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Posts
    76
    Rep Power
    12

    changes datatype


    hi...i got a question to ask..
    i'm using the oracle. i'd like to change the datatype number, from 2 digits to 5 digits. How to do that in sql query.
    My table name is ac_door. Thank you!

    Name Null? Type
    ----------------------------------------- -------- -----------
    ACDR_ISSNO NOT NULL NUMBER(2)
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,784
    Rep Power
    348
    alter table ac_door modify acdr_issno number(5);

    Read the docs!
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Posts
    76
    Rep Power
    12
    Thank you. do u know where to find the online oracle tutorial?
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,784
    Rep Power
    348
    http://docs.oracle.com

    And they are included with the Oracle installation

IMN logo majestic logo threadwatch logo seochat tools logo