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

19 votes145 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
6 votes120 views4 answers
Sqlite drop table
SQL
0 vote138 views3 answers
Sql query checker
SQL
10 votes132 views3 answers
How to fetch first 5 characters in sql
SQL
4 votes138 views1 answer
Conda install sqlalchemy
SQL
0 vote251 views1 answer
Generate a random otp in sql server
SQL
2 votes117 views1 answer
Mysql increment value by 1 in update
SQL
11 votes137 views2 answers
How to import mysql database command line
SQL
0 vote139 views1 answer
Default column value in sql same as another column laravel
SQL
0 vote120 views1 answer
Parsing float to int in mysql
SQL