Add a column and rename a column - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Add a column and rename a column

  1. #11
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Sory, I must excuse myself. I just checked the documentation, and there is no such thing as directly renaming a column in 8.1.7. I know I've read about this new SQL enhancement, I thought it was about 8i rel.3, but it obviously must have been a white paper of new features of 9i.

    So until then, we will have to stick with that clums CREATE_NEW_COL -> POPULATE_FROM_OLD_COL -> DROP_OLD_COL method.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  2. #12
    Join Date
    Oct 2000
    Posts
    123
    No wonder i search docus 8.1.7 but can not find it,
    but thanks for your infos about 9i.

    Take care

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width