Mega Code Archive

 

Categories / Oracle PLSQL / Table

 

Creating an index-organized table

SQL> -- Creating an index-organized table: SQL> SQL> create table states (   2        state_id         varchar2(2),   3        state_name       varchar2(20),   4        constraint states_pk   5          primary key (state_id)   6      )   7      organization index   8      / Table created. SQL> SQL> drop table states;