/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 vote253 views1 answer
Mysql connect command
SQL
0 vote242 views1 answer
Sqlite update where exists
SQL
0 vote201 views1 answer
The fetch keyword oracle
SQL
1 vote196 views3 answers
SELECT * FROM
SQL
1 vote183 views1 answer
Oracle case
SQL
0 vote162 views1 answer
Full syntax inner join
SQL
-2 votes175 views3 answers
Oracle tablespace usage
SQL
1 vote172 views1 answer
How to use a trigger to validate input data
SQL
0 vote217 views1 answer
Sp help text in postgresql
SQL
0 vote185 views1 answer
Flexible search query delete table
SQL