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 vote206 views1 answer
How to check replication lag in mySQL
SQL
1 vote213 views1 answer
Oracle case
SQL
0 vote226 views1 answer
Alter fedora mysql 8.0 user
SQL
2 votes221 views6 answers
In operator in sql
SQL
0 vote216 views1 answer
Multiple tricky query in sql server
SQL
0 vote206 views1 answer
Sql query to check if column contains alphabets
SQL
4 votes225 views1 answer
Mysql ip address data type
SQL
14 votes218 views1 answer
Oracle new column
SQL
2 votes202 views2 answers
Function in sql
SQL
0 vote216 views1 answer
Recover deleted data from mysql database
SQL