7 Replies Latest reply on Apr 18, 2007 10:27 AM by ushitaki

    How to rename a column...

    544878
      Hi

      How to rename a more than one column in a single query?

      Below query for renaming a single column.
      ALTER TABLE EMP RENAME COLUMN <OLD-COL> TO <NEW_COL>.

      more than one column, how to do in a single query?

      Regards
      Sathya