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

7 votes371 views2 answers
Mysql get year from date
SQL
4 votes357 views1 answer
Refresh postgres config
SQL
0 vote345 views1 answer
Disableforiegn key check
SQL
57 votes597 views5 answers
How to create a new user in postgresql
SQL
0 vote349 views1 answer
Default password for mysql_secure_installation in mac
SQL
2 votes381 views1 answer
Sqlplus clear screen
SQL
7 votes363 views2 answers
Html to react converter
SQL
2 votes359 views1 answer
How to show the whole table in sql
SQL
2 votes397 views1 answer
Create mysql user on all hosts
SQL
0 vote372 views1 answer
Excel vba import data to sql server
SQL