Skip to Main Content
Forums

SQL & PL/SQL

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!

Adding a new column in table

9876564Oct 19 2016 — edited Oct 19 2016

Hello Gurus ,

Oracle Version : 11.2.0.2.0

I need to add a new column in an existing table without dropping it

table structure is

   

Emp_noEmp_name Departmement
1234MichalPPS
1235MoureenPPS
1276LixaLRTS
1288TimPrime

I need to add a new column (say address) after emp_no , do we have any option to add the same without getting the table dropped ?

   

Emp_noAddressEmp_name Departmement
1234 MichalPPS
1235 MoureenPPS
1276 LixaLRTS
1288 TimPrime
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 16 2016
Added on Oct 19 2016
15 comments
2,486 views