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 vote150 views3 answers
Above average salary in sql
SQL
12 votes152 views1 answer
Docker mysql random root password
SQL
0 vote178 views1 answer
Create dabase postgresql
SQL
0 vote150 views1 answer
How to fix mysql stop unexpectedly
SQL
8 votes145 views1 answer
Alter tablespace add datafile
SQL
-1 vote156 views1 answer
Select first rows postgresql
SQL
0 vote149 views1 answer
Mysql case when on date
SQL
0 vote153 views1 answer
Postgresql default value boolean
SQL
5 votes145 views2 answers
Add column postgres with default value
SQL
0 vote155 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL