/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

0 vote217 views1 answer
Microsoft word insert sql code
SQL
0 vote196 views1 answer
Mssql disable foreign key constraint
SQL
4 votes188 views2 answers
Oracle last day of month
SQL
0 vote188 views1 answer
Create new schema mysql
SQL
0 vote194 views1 answer
Not between mysql
SQL
0 vote340 views1 answer
Sqlite display data in separated columns
SQL
0 vote189 views1 answer
Mysql does collate nopad recognize space
SQL
0 vote185 views1 answer
Postgres float to int
SQL
0 vote180 views1 answer
Mysql find foreign key references
SQL
1 vote211 views1 answer
Replace all numbers in mysql
SQL