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

8 votes275 views4 answers
Mysql update one table from another table multiple columns
SQL
53 votes547 views6 answers
How to install mysql ubuntu
SQL
13 votes280 views6 answers
Restart postgresql
SQL
1 vote271 views1 answer
Postgres count string length
SQL
1 vote259 views1 answer
SQLSTATE[HY000] [2002]
SQL
0 vote277 views1 answer
Sql trying to delete database in use
SQL
0 vote293 views1 answer
Get current date data in mysql
SQL
0 vote258 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote269 views1 answer
How to check default value of column in sql server
SQL
0 vote351 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL