1. Hey Guest Did you know you can win an Honor 10 phone worth ₹33,000 and an additional ₹70,000 in paytm vouchers, just by replying to some threads and taking part in the discussions happening in the Honor Hub?

    What are you waiting for? Start commenting and start winning! Remember to read the instructions posted here.

    Dismiss Notice

oracle datatype

Discussion in 'QnA (read only)' started by Trinity, Apr 16, 2006.

Thread Status:
Not open for further replies.
  1. Trinity

    Trinity New Member

    Joined:
    Feb 10, 2004
    Messages:
    125
    Likes Received:
    0
    Trophy Points:
    0
    hello there,



    I am working on Oracle 9i and i m in a fix , cud tell a way to change data size .

    presicely, i have a colum of datatype varchar(14), wanna change it to varchar2(40). is there a way besides re-creating it??
     
  2. kalpik

    kalpik In Pursuit of "Happyness"

    Joined:
    May 18, 2005
    Messages:
    3,002
    Likes Received:
    15
    Trophy Points:
    0
    Location:
    New Delhi
    alter table <tablename> modify <columnname> varchar2(40);

    Try this..
     
  3. OP
    OP
    Trinity

    Trinity New Member

    Joined:
    Feb 10, 2004
    Messages:
    125
    Likes Received:
    0
    Trophy Points:
    0
    whooopiii! it worked....thanx
     
  4. kalpik

    kalpik In Pursuit of "Happyness"

    Joined:
    May 18, 2005
    Messages:
    3,002
    Likes Received:
    15
    Trophy Points:
    0
    Location:
    New Delhi
    Hehe so!! I still remember oracle hehe..
     
Thread Status:
Not open for further replies.

Share This Page