Oracle Base Statement

1 、--Create an index, after it is created, is stored in ascending order of last_name value, it_lastname as the index name

Create [unique] [cluster] index name on table name (field name);

Unique: Index values cannot be duplicated.

Cluster: The index established is a clustered index.

Create INDEX It_lastname on it_employees (last_name);

2. Delete a table

Delete statement when a base table is no longer needed

drop table name;

Delete a view

Drop view name;

Delete Index

Drop index name;

Oracle Base Statement