Partitioning in oracle-base

CREATE TABLE invoices
(invoice_no    NUMBER NOT NULL,
 invoice_date  DATE   NOT NULL,
 comments      VARCHAR2(500))
PARTITION BY RANGE (invoice_date)
(PARTITION invoices_q1 VALUES LESS THAN (TO_DATE('01/04/2001', 'DD/MM/YYYY')) TABLESPACE users,
 PARTITION invoices_q2 VALUES LESS THAN (TO_DATE('01/07/2001', 'DD/MM/YYYY')) TABLESPACE users,
 PARTITION invoices_q3 VALUES LESS THAN (TO_DATE('01/09/2001', 'DD/MM/YYYY')) TABLESPACE users,
 PARTITION invoices_q4 VALUES LESS THAN (TO_DATE('01/01/2002', 'DD/MM/YYYY')) TABLESPACE users);

Source: oracle-base.com

Similar codes

1 vote333 views1 answer
How much every mysql database record takes from diskspace
SQL
0 vote330 views1 answer
Mssql describe stored procedure sqlcmd
SQL
0 vote350 views4 answers
How to connect form to database
SQL
0 vote346 views2 answers
Sql join on comma separated field
SQL
-1 vote370 views1 answer
How to change the auto increment in existing table mysql
SQL
11 votes375 views5 answers
Update table from another table mysql
SQL
1 vote364 views1 answer
Sql dcl
SQL
1 vote388 views2 answers
Mysql limit offset
SQL
1 vote348 views1 answer
Sqlite show columns in table
SQL
0 vote415 views1 answer
Sql query inline if
SQL