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 vote315 views1 answer
Mysql limit order by
SQL
3 votes309 views2 answers
Sql server current date without time
SQL
0 vote290 views1 answer
Equi joins in oracle
SQL
0 vote302 views1 answer
Sql server change schema of a table
SQL
-1 vote317 views5 answers
Not in sql
SQL
0 vote290 views1 answer
T-SQL - Where Used List (Table/View)
SQL
3 votes299 views1 answer
Oracle failed login attempts
SQL
0 vote291 views1 answer
How to check the port of mysql installation in mac
SQL
0 vote281 views1 answer
Mysql select last 15 minutes
SQL
0 vote338 views2 answers
Sql unique
SQL