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 vote150 views1 answer
Mysql foreach insert
SQL
0 vote191 views1 answer
Reset a table's identity column and remove test records
SQL
1 vote199 views1 answer
Sql comment header
SQL
1 vote143 views1 answer
How to open closed port mysql in ubuntu
SQL
0 vote155 views1 answer
Mysql date equals to current_date plus days
SQL
0 vote154 views4 answers
How to get max salary in each department in sql
SQL
-1 vote136 views1 answer
Extract Data from SQL Server into XML Format
SQL
0 vote145 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote225 views1 answer
Get statis values sql
SQL
7 votes154 views1 answer
Grant schema permissions postgres
SQL