Mega Code Archive

 

Categories / Oracle PLSQL / Index

 

Create an index reverse

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 emp_empno_pk   2  on emp(empno) reverse; Index created. SQL> SQL> drop table emp; Table dropped. SQL>