7 Replies Latest reply on Jul 23, 2015 7:16 AM by Paul Horth

    How to add new column at a specific position

    venkatesh867

      Hi,

       

      My table looks as fallows.

       

      select * from company

      PRODUCT_IDCOMPANY_IDCOMPANY_SHORT_NAMECOMPANY_LONG_NAME
      11001A Inc.Long Name A Inc.
      11002B Inc.Long Name B Inc.
      11003C Inc.Long Name C Inc.
      21004D Inc.Long Name D Inc.
      21005E Inc.Long Name E Inc.
      21006F Inc.Long Name F Inc.

       

      My requirement is I WANT TO ADD A NEW COLUMN AS COMPANY_LOCATION NEXT TO COMPANY_SHORT_NAME

      How to achieve this.


      I tried as fallows alter table company add company_location varchar2(100) after company_short_name;

      but this query shows the error

      ORA-01735: invalid ALTER TABLE option

      Whether the query which i tried is correct?

      Give me your suggestions.

      Thanks in Advance.