1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

about unused column

Discussion in 'SQL PL/SQL' started by oracle123, Oct 14, 2009.

  1. oracle123

    oracle123 Active Member

    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    80
    can we set unused column as used ???
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Could you care to explain a little more?
     
  3. oracle123

    oracle123 Active Member

    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    80
    we use to set column as unused --
    ALTER TABLE emp
    SET UNUSED COLUMN comm;

    this unused info we get from USER_UNUSED_COL_TABS ..

    so can we again able to use unused column ???

    means i want to again use comm column ..
    is this possible ??? how ???

    thanks....
     
  4. Sikkandar.S.P

    Sikkandar.S.P Active Member

    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    80
    Location:
    Chennai
    No, You cannot do it! Its not possible to make use of UNUSED Columns!
     
  5. oracle123

    oracle123 Active Member

    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    80
    thanks a lot