/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 vote98 views1 answer
Update table sql multiple set
SQL
3 votes112 views3 answers
Mysql declare variable
SQL
1 vote118 views1 answer
Postgres set sequence value to max id
SQL
0 vote126 views1 answer
Migrations.RunSQL
SQL
1 vote98 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
8 votes106 views1 answer
Oracle current date plus 1 month
SQL
0 vote100 views2 answers
Sql update top 100
SQL
0 vote108 views2 answers
2nd max salary query in sql
SQL
0 vote95 views1 answer
Mysql use password error
SQL
0 vote99 views1 answer
Search db for table name
SQL