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






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.








9.1.Create Index
9.1.1.Creating an Index
9.1.2.Enforce uniqueness of values in a column using a unique index
9.1.3.Create combined-column index
9.1.4.Create a composite index on multiple columns
9.1.5.Creating a Function-Based Index
9.1.6.Create index based on cluster
9.1.7.Creates an index on the new added column
9.1.8.Create a fully indexed table named myCode
9.1.9.indextype is ctxsys.context
9.1.10.Create index for upper case last name
9.1.11.Create index along with the column definition
9.1.12.Create index for combined columns
9.1.13.Create unique index and check it in user_ind_columns and user_cons_columns
9.1.14.Demonstrate a bitmap join index.
9.1.15.create unique index with case ... when statement
9.1.16.Create Non-Unique index
9.1.17.autotrace ctxsys.context index
9.1.18.Create index with tablespace