/SQL/Create-table-with-index-organization

Create-table-with-index-organization

create table bricks_iot (
  bricks_id integer primary key
) organization index;

select table_name, iot_type
from   user_tables
where  table_name = 'BRICKS_IOT';

Source: livesql.oracle.com

Similar codes

1 vote261 views1 answer
Oracle apex version view
SQL
0 vote197 views1 answer
Sql contains vs like
SQL
0 vote208 views1 answer
Create or replace view postgress
SQL
0 vote204 views1 answer
Oracle drop type
SQL
0 vote241 views1 answer
Sql date with year
SQL
20 votes202 views2 answers
Mysql bigint max value
SQL
0 vote206 views1 answer
Get duplicate entry sql
SQL
0 vote213 views1 answer
Select odd records sql
SQL
1 vote264 views1 answer
Postgres set sequence value to max id
SQL
4 votes199 views2 answers
Oracle last day of month
SQL