/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

23 votes224 views4 answers
How to show all users in mysql
SQL
1 vote214 views1 answer
Cross schema query oracle 2 users
SQL
0 vote196 views1 answer
Sql change default collation to utf8
SQL
0 vote200 views1 answer
Grant access on table in oracle
SQL
1 vote211 views2 answers
How to search date in sql query
SQL
1 vote212 views2 answers
Oracle 18c xe ORA-65096
SQL
7 votes203 views4 answers
Database dump mysql command
SQL
23 votes233 views5 answers
Sql substring
SQL
1 vote202 views1 answer
Drop table if exists oracle
SQL
2 votes228 views1 answer
Metasploit start postgresql
SQL