/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 vote225 views1 answer
Wordpress make wp user in db
SQL
0 vote198 views1 answer
Postpresql relation not found
SQL
0 vote216 views1 answer
No query unable to fetch row sqlite
SQL
5 votes211 views3 answers
String concatenation sql server
SQL
1 vote268 views1 answer
Sql select contem uma palavra
SQL
61 votes1.2K views6 answers
Mysql add column
SQL
3 votes183 views1 answer
Oracle revoke grant
SQL
0 vote192 views1 answer
Mysql count unique in group statement
SQL
3 votes279 views2 answers
How to modify rows in SQL Server
SQL
1 vote215 views1 answer
Mysql drop key
SQL