/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 vote157 views1 answer
How to select department from table
SQL
4 votes116 views1 answer
Wilayah indonesia sql
SQL
5 votes110 views1 answer
Sql check if date is between 2 dates
SQL
1 vote103 views1 answer
Group_concat max length mysql
SQL
0 vote104 views1 answer
Add colum date in sql
SQL
0 vote117 views1 answer
Mysql update even / odd rows
SQL
0 vote114 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
1 vote100 views1 answer
Oracle lock user
SQL
0 vote97 views1 answer
Oracle 11g forget password
SQL
0 vote95 views1 answer
Lister les index d'une table oracle
SQL