ddl-sql: how to delete column from table

Hi,
could someone tell me how to delete a column from a table? i've used the sql:

"ALTER TABLE table_name DROP column_name"

but it seems it doesn't work for Oracle.

Thanks,

Pedro. Received on Tue Jul 06 1999 - 07:30:00 CDT