/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 vote320 views2 answers
How to tun mysql on ubunto
SQL
0 vote327 views1 answer
Set default value now() date
SQL
0 vote321 views2 answers
Android sqlite query join
SQL
1 vote316 views2 answers
Copy database mysql
SQL
0 vote318 views1 answer
Mysql select statement after index
SQL
54 votes513 views6 answers
Sql rename column
SQL
1 vote311 views1 answer
Importance of comment in mysql
SQL
0 vote346 views2 answers
Unique key
SQL
0 vote338 views1 answer
How to select all fieldsin a soql query
SQL
3 votes323 views2 answers
Sql paging query
SQL