SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to add new column at a specific position

venkatesh867Jul 22 2015 — edited Jul 23 2015

Hi,

My table looks as fallows.

select * from company

PRODUCT_ID	COMPANY_ID	COMPANY_SHORT_NAME	COMPANY_LONG_NAME
1	1001	A Inc.	Long Name A Inc.
1	1002	B Inc.	Long Name B Inc.
1	1003	C Inc.	Long Name C Inc.
2	1004	D Inc.	Long Name D Inc.
2	1005	E Inc.	Long Name E Inc.
2	1006	F 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.

This post has been answered by cpe on Jul 22 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 20 2015

Added on Jul 22 2015

#sql-developer

7 comments

3,200 views