In Oracle SQL, the DROP statement is used to delete database objects like tables, views, indexes, sequences, etc. The syntax varies depending on the object type.
1. DROP TABLE
Deletes a table and its data permanently.
Syntax
DROP TABLE table_name;
Example :
DROP TABLE employees;