/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 vote168 views1 answer
Create view in mysql workbench
SQL
0 vote133 views1 answer
How to reset AI in sql
SQL
0 vote126 views1 answer
Running query in redshift
SQL
0 vote127 views1 answer
Sql query to select records entered in last 24 hours
SQL
0 vote138 views5 answers
Linq cheat sheet
SQL
6 votes146 views4 answers
Remove spaces sql server
SQL
1 vote154 views1 answer
T-SQL / AZURE Reseed
SQL
0 vote142 views1 answer
Utiliser sql ligne de commande
SQL
0 vote151 views1 answer
Sql drop default
SQL
8 votes145 views2 answers
Alert table name mysql
SQL