Skip to Main Content

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!

Drop/Delete Column

BilalKhanMar 2 2011 — edited Mar 2 2011
Hello Every Body.
i want to drop/delete the column of the table,so how can i do that?
For example. i have table

CREATE TABLE CUSTOMER
(
Customer_ID NUMBER,
Customer_Name VARCHAR2(10),
Street VARCHAR2(10),
City VARCHAR2(10),
State VARCHAR2(10),
Postal_Code NUMBER,
PRIMARY KEY (Customer_ID)
);

now i want to Delete the column Postal_Code .
So what should i do??

Regards
This post has been answered by Lokanath Giri on Mar 2 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 30 2011
Added on Mar 2 2011
1 comment
71 views