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

0 vote131 views1 answer
Sql last 3 rows
SQL
3 votes139 views1 answer
How to uninstall microsoft sql server
SQL
-1 vote166 views1 answer
Minus vs except in sql
SQL
0 vote290 views1 answer
The package java.sql is not accessible
SQL
3 votes125 views1 answer
Oracle list invalid password ORA-01017
SQL
2 votes132 views1 answer
Where clause for child record apex
SQL
1 vote158 views1 answer
Show databases mysql docker
SQL
0 vote126 views2 answers
Script all indexes in a database
SQL
3 votes125 views1 answer
Laravel database Using Named Bindings
SQL
0 vote122 views1 answer
Sql get count without group by
SQL