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>
Related examples in the same category