Create a fully indexed table named myCode
SQL>
SQL> create table myCode(
2 codeValue VARCHAR2(1) primary key,
3 Description VARCHAR2(25)
4 );
Table created.
SQL>
SQL> create index i1 on myCode (codeValue, Description);
Index created.
SQL>
SQL>
SQL> drop index i1;
Index dropped.
SQL>
SQL> drop table myCode;
Table dropped.
Related examples in the same category