/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

19 votes172 views5 answers
Change column name mysql command line
SQL
4 votes177 views2 answers
Mysql show indexes on table
SQL
0 vote188 views1 answer
Sql use with to get value counts and percentages
SQL
1 vote169 views1 answer
Oracle apex run 404
SQL
2 votes171 views2 answers
How to check database username and password in postgresql
SQL
0 vote175 views1 answer
Mysql c commands
SQL
0 vote157 views1 answer
Sql orcale i forgot what my name & password was
SQL
0 vote197 views1 answer
Parent and child link in mysql
SQL
17 votes165 views2 answers
Mysql date to string
SQL
0 vote192 views1 answer
Sql basic commands
SQL