How to add a new column to a table in Sql*plus

Hello there,

I created a table with sql*plus and wanted to add a new column to it. Could somebody tell me how please?

Quote:

---

Originally Posted by cracboy

I created a table with sql*plus and wanted to add a new column to it. Could somebody tell me how please?

---

Anything wrong with ALTER TABLE ADD COLUMN syntax?
Please check here for details... http://docs.oracle.com/cd/B12037_01/...ments_3001.htm

Perhaps Oracle changed the syntax and failed to notify us?
:p