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

3 votes217 views3 answers
Mysql declare variable
SQL
21 votes172 views7 answers
Table drop if exist sql server
SQL
0 vote213 views1 answer
Oarcale list objects
SQL
0 vote227 views1 answer
Sql out file formate
SQL
0 vote216 views1 answer
Mariadb create index if not exists
SQL
11 votes217 views2 answers
Insert date sql
SQL
2 votes259 views3 answers
Mysql unix timestamp to date
SQL
0 vote197 views1 answer
How to find top 3 salary in sql
SQL
1 vote205 views1 answer
Sql server 2012 query history
SQL
5 votes194 views4 answers
Select random rows sql
SQL