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 vote154 views1 answer
Time data type in mysql
SQL
8 votes143 views4 answers
How to calculate the age from date of birth in python
SQL
57 votes302 views5 answers
How to create a new user in postgresql
SQL
0 vote124 views2 answers
Homebrew nysql launch
SQL
1 vote137 views1 answer
Display total number of tables in mysql
SQL
1 vote121 views1 answer
PLS-00225 type
SQL
11 votes159 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
3 votes116 views1 answer
Oracle nextval
SQL
0 vote147 views1 answer
Mysql order by where condition sub query
SQL
0 vote193 views1 answer
Placements hackerrank solution
SQL