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 vote171 views1 answer
Openquery join two tables
SQL
0 vote158 views1 answer
Insert into Select * - NAYCode.com
SQL
0 vote180 views1 answer
Sql server rtrim everything after character
SQL
2 votes147 views1 answer
Oracle table size
SQL
0 vote146 views1 answer
FIND most frequent word in sql server
SQL
0 vote183 views1 answer
Oracle current date minus 1 day
SQL
0 vote176 views1 answer
Sql basic commands
SQL
0 vote158 views1 answer
Stratified sampling sql
SQL
1 vote147 views1 answer
Mariadb get column names from table
SQL
0 vote148 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL