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

1 vote196 views1 answer
Load sql into mamp
SQL
-2 votes205 views2 answers
Add auto_increment column to existing table mysql
SQL
6 votes198 views2 answers
Stored procedure to delete data from table in mysql
SQL
4 votes209 views2 answers
Bulk kill mysql processlist
SQL
1 vote178 views1 answer
Select dba users oracle
SQL
0 vote197 views1 answer
Sql add calculated column
SQL
0 vote203 views1 answer
How to remove default in mysql
SQL
1 vote256 views1 answer
Sql sort column by date
SQL
0 vote212 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote192 views1 answer
Split string by comma in sql server
SQL