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

1 vote217 views2 answers
Create table if not exist
SQL
0 vote234 views1 answer
Plsql check how much space all databases are consuming
SQL
3 votes356 views6 answers
Sql unique select
SQL
0 vote201 views1 answer
Sql find record cannot cast date
SQL
3 votes206 views2 answers
See mysql users ubuntu
SQL
0 vote198 views1 answer
Postgres can integer fields be negative
SQL
0 vote218 views1 answer
Add two days to current date in sql when creating tables
SQL
11 votes196 views1 answer
Creating tables in sql with python
SQL
0 vote211 views4 answers
Forenkey code alchemy sql
SQL
0 vote239 views2 answers
How to install psql in ubuntu
SQL