/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

9 votes243 views4 answers
SQL Date Format
SQL
0 vote254 views1 answer
Repeatable read trong sql server
SQL
0 vote231 views1 answer
How to use group_concat in sql server
SQL
0 vote250 views1 answer
Limit in access query
SQL
1 vote227 views1 answer
Search for tables with name postgresql
SQL
5 votes248 views1 answer
Oracle sysdate - 1 month
SQL
0 vote227 views1 answer
Sql fetch next 10 rows pdo
SQL
0 vote257 views1 answer
Vs 2019 connect to local mysql database
SQL
0 vote230 views1 answer
How to check default value of column in sql server
SQL
1 vote238 views1 answer
Oracle activate job
SQL