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 vote216 views1 answer
Time in sql server
SQL
7 votes203 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
14 votes173 views4 answers
Remove record from table sql
SQL
1 vote225 views3 answers
Nth highest salary
SQL
20 votes171 views1 answer
Get all table name in sql through php
SQL
1 vote195 views1 answer
Tsql replace value in json
SQL
0 vote155 views1 answer
Finish transaction sql
SQL
0 vote193 views1 answer
Cube oracle
SQL
1 vote241 views1 answer
Tsql create unique index composite
SQL
0 vote137 views1 answer
Psql not found windows
SQL