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

20 votes271 views4 answers
Sql count if
SQL
11 votes239 views1 answer
Oracle view ddl
SQL
12 votes237 views5 answers
Sql merge
SQL
1 vote207 views1 answer
Mysql get last insert id
SQL
-1 vote234 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
-1 vote224 views1 answer
What is in operator
SQL
0 vote232 views1 answer
Sql string contains case sensitive
SQL
1 vote237 views1 answer
PLS-00225 type
SQL
0 vote237 views1 answer
Turn on foreign keys check mysql
SQL
1 vote241 views1 answer
Mysql list bigger table
SQL