Mega Code Archive

 

Categories / Oracle PLSQL / Index

 

Function-based Indexes

SQL> SQL> CREATE TABLE EMP (EMPNO NUMBER(4) NOT NULL,   2                    ENAME VARCHAR2(10),   3                    JOB VARCHAR2(9),   4                    MGR NUMBER(4),   5                    HIREDATE DATE,   6                    SAL NUMBER(7, 2),   7                    COMM NUMBER(7, 2),   8                    DEPTNO NUMBER(2)); Table created. SQL> SQL> create index upper_name_idx on emp(upper(ename)); Index created. SQL> SQL> SQL> drop table EMP; Table dropped. SQL> SQL>