Mega Code Archive

 

Categories / Oracle PLSQL / Table

 

An example of creating an index-organized table

SQL> SQL> create table states (   2    state_id         varchar2(2),   3    state_name       varchar2(20),   4    constraint states_pk primary key (state_id)   5  )   6  organization index; Table created. SQL> SQL> SQL> drop table states; Table dropped. SQL> SQL>