/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 vote283 views1 answer
Sql find record cannot cast date
SQL
12 votes281 views10 answers
Google
SQL
0 vote289 views1 answer
Querry mysql by 2 columns
SQL
0 vote256 views1 answer
Create column that already exists mysql
SQL
0 vote279 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
2 votes270 views1 answer
Brew start postgres manual
SQL
0 vote267 views1 answer
Postgresql default value boolean
SQL
20 votes282 views1 answer
Sql change column types
SQL
0 vote275 views1 answer
How to see password mysql vestacp
SQL
4 votes323 views4 answers
Mysql get date from datetime
SQL