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 vote152 views1 answer
How to truncate a table in databse
SQL
1 vote141 views3 answers
Read all columns of a table sql
SQL
1 vote150 views1 answer
Sql select whole row max column
SQL
0 vote134 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
1 vote157 views1 answer
Default
SQL
0 vote153 views1 answer
How to read the potentail error messages in ssis package
SQL
0 vote189 views1 answer
Oracle show running job
SQL
0 vote181 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
0 vote158 views1 answer
Check if a column is a primary key in sql server
SQL
7 votes151 views3 answers
Sql set
SQL