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 vote157 views1 answer
Order by oracle
SQL
1 vote201 views2 answers
How to add amount between date in sql
SQL
1 vote413 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
0 vote133 views1 answer
Sql select rows with simlar names
SQL
0 vote187 views1 answer
Select new table sql
SQL
0 vote179 views1 answer
Sql requete number pair
SQL
0 vote159 views1 answer
Mysql show category once count how many products
SQL
1 vote247 views1 answer
How to select the nth row in a SQL database table?
SQL
0 vote159 views1 answer
Join creating duplicate columns sqllite
SQL
0 vote175 views1 answer
Print orcale
SQL