Index Oracle PLSQL Tutorial

SQL>
SQL> CREATE TABLE person (
  2       person_code VARCHAR2(3) PRIMARY KEY,
  3       first_name  VARCHAR2(15),
  4       last_name   VARCHAR2(20),
  5       hire_date   DATE
  6       );
Table created.
SQL>
SQL> CREATE INDEX person_name_index ON person(last_name, first_name);
Index created.
SQL>
SQL> drop index person_name_index;
Index dropped.
SQL>
SQL> drop table person;
Table dropped.
SQL>