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

22 votes354 views4 answers
Mysql date_format
SQL
1 vote356 views1 answer
Table valued functions in sql
SQL
0 vote321 views1 answer
Mysql regex exact match
SQL
0 vote352 views1 answer
Kill slow queries mysql
SQL
4 votes362 views1 answer
Sql select limit range
SQL
0 vote329 views1 answer
Mysql add root password
SQL
1 vote320 views1 answer
Sql myisam vs innodb
SQL
6 votes279 views2 answers
Generate c# class from sql server table
SQL
2 votes359 views1 answer
Mysql trigger after update
SQL
11 votes311 views2 answers
Having keyword sql
SQL