delete all table in oracle code example

Example 1: delete column from table oracle PL SQL

ALTER TABLE table_name DROP COLUMN column_name;

Example 2: how to remove tablespace in oracle

DROP TABLESPACE tbs_02
   INCLUDING CONTENTS AND DATAFILES;