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 vote319 views1 answer
Find wordpress version in database
SQL
12 votes355 views6 answers
How to install sqlite3 in python
SQL
0 vote339 views1 answer
Oracle array
SQL
0 vote315 views1 answer
IIF
SQL
0 vote370 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
6 votes336 views3 answers
Oracle all dates between two dates
SQL
0 vote326 views2 answers
Sqlite unix timestamp
SQL
6 votes355 views3 answers
How to delete table sqlite
SQL
0 vote355 views1 answer
Create synonym for dblink in oracle
SQL
2 votes324 views1 answer
Oracle list grants on package
SQL