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 vote259 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
0 vote257 views4 answers
How to drop all tables in sql
SQL
3 votes270 views2 answers
How to start postgresql on windows
SQL
3 votes265 views2 answers
Oracle synonym
SQL
1 vote270 views1 answer
Sql eliminare un record
SQL
0 vote271 views1 answer
Mysql count grouped rows
SQL
1 vote266 views1 answer
Get table which have specific columns in mysql
SQL
10 votes274 views2 answers
Show tables in schema oracle
SQL
1 vote235 views1 answer
Foreign key in oracle sql developer
SQL
2 votes296 views1 answer
Alter table add column and foreign key mysql
SQL