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 vote115 views1 answer
Limit in access query
SQL
1 vote96 views1 answer
Launch sql script from docker in mysql
SQL
0 vote105 views1 answer
Mysql workbench procedure
SQL
0 vote107 views1 answer
Mysql backup certain tables workbench
SQL
1 vote115 views1 answer
Last 24 HOUR data in mysql
SQL
2 votes99 views2 answers
Exec procedure pl sql
SQL
3 votes107 views2 answers
Get current year sql
SQL
0 vote113 views1 answer
Sql query to find duplicate email address
SQL
0 vote95 views2 answers
Select columns from 2 tables with foreign key
SQL
0 vote118 views1 answer
Permission denied postgres \copy csv command line
SQL