ORACLE - How to drop one table column in ORACLE Database?

Great spirits have always found violent opposition from
mediocrities. The latter cannot understand it when a man does not
thoughtlessly submit to hereditary prejudices but honestly and
courageously uses his intelligence.

— Albert Einstein

ORACLE - How to drop one table column in ORACLE Database?

Fri, 11/19/2010 - 20:32 |

Juraj Maslik

You can drop column of table using the DROP clause of the ALTER TABLE statement.

ALTER TABLE
  TBL_COLUMN
DROP COLUMN_NAME