var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Dropping a column from table
I am trying to drop a column (column does not have any data, not a key) using the following command.
alter table plant drop column plant_supplier;
Oracle throws the following error ORA-00905: Missing Keyword.
Could any one please advise what is happening?
Re: Dropping a column from table
What Oracle version? Probably one that doesn't support dropping columns. The syntax is fine:
SQL> alter table t drop column c;