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

16 votes180 views2 answers
Add column if not exists mysql
SQL
0 vote171 views1 answer
Hashpass
SQL
0 vote177 views1 answer
Mysql calculated column
SQL
0 vote160 views1 answer
Sql offfset
SQL
1 vote181 views1 answer
Postgresql float 2 decimal places
SQL
0 vote135 views1 answer
Sql new line output
SQL
6 votes167 views1 answer
Allsource oracle
SQL
1 vote190 views2 answers
Mysql add column tinyint default 0
SQL
2 votes165 views1 answer
Drop table purge
SQL
1 vote138 views1 answer
Database run
SQL