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

5 votes131 views1 answer
Pl sql asynchronous procedure calls
SQL
0 vote137 views1 answer
Alter table engine mysql
SQL
0 vote139 views1 answer
Rename constraint postgresql
SQL
9 votes138 views6 answers
Sql add column with default value
SQL
0 vote142 views1 answer
Hex string sql becomes int64
SQL
3 votes132 views1 answer
Show index table
SQL
2 votes127 views1 answer
While loop sql
SQL
1 vote133 views1 answer
Mysql count words
SQL
0 vote128 views1 answer
Postgres data location
SQL
2 votes129 views2 answers
Enable foreign key checks postgres
SQL