Create index along with the column definition : Create Index « Index « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Index
3. Create Index

SQL>
SQL>
SQL> CREATE TABLE emp2
  2  (emp_id        NUMBER PRIMARY KEY
  3                  USING INDEX
  4                  (CREATE INDEX pk_idx ON emp2(emp_id) TABLESPACE users)
  5   ,lastname      VARCHAR2(20) CONSTRAINT lastname_create_nn NOT NULL
  6   ,firstname     VARCHAR2(15) CONSTRAINT firstname_create_nn NOT NULL
  7   ,phone     VARCHAR2(12)
  8   ,company_name  VARCHAR2(50)
  9   ,CONSTRAINT unique_emp_phone UNIQUE (phone)
 10    USING INDEX
 11   (CREATE INDEX phone_idx ON emp2 (phone) TABLESPACE users)
 12   );

Table created.

SQL>
SQL>
SQL> drop table emp2;

Table dropped.