/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

2 votes314 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
1 vote296 views1 answer
Count of tables in database mysql
SQL
0 vote306 views1 answer
Nosql vs sql
SQL
0 vote299 views1 answer
Dapper run sql script with parameters
SQL
0 vote326 views3 answers
Sql server obtener fecha en formato dd/mm/yyyy
SQL
0 vote302 views1 answer
List all functions and procedures in postgres query
SQL
2 votes313 views1 answer
Query any digits record
SQL
0 vote307 views1 answer
Connect to ssms with python
SQL
0 vote378 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
1 vote308 views1 answer
How to unlock table in mysql
SQL