/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 vote359 views1 answer
How to read the potentail error messages in ssis package
SQL
0 vote385 views1 answer
Database schema for mcqs type exam in sql
SQL
0 vote364 views1 answer
DATEDIFF minute postgres
SQL
20 votes367 views3 answers
Update values in select statement sql
SQL
1 vote354 views1 answer
Where to locate set password for mysql
SQL
0 vote353 views1 answer
Select from column mysql
SQL
0 vote345 views1 answer
Copied text from internet not inserting in mysql
SQL
0 vote346 views1 answer
Mysql select where field is a value
SQL
0 vote396 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
0 vote439 views1 answer
How to check foreign key constraint in sql
SQL