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 vote180 views1 answer
Hive batch drop table
SQL
16 votes181 views3 answers
Delete row psql
SQL
0 vote185 views1 answer
Dbms_output sql developer
SQL
1 vote184 views3 answers
Mysql connection string
SQL
0 vote195 views1 answer
Python dictionary to sql update
SQL
0 vote178 views1 answer
Sql gap missing values
SQL
17 votes205 views5 answers
Order by sql
SQL
0 vote186 views1 answer
Postgres sql alter table delete row
SQL
1 vote174 views1 answer
Use of now() in mysql
SQL
1 vote182 views1 answer
ORA-01950
SQL