Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Index

 

Create combined-column index

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>