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 vote129 views1 answer
Executescalar in sql server
SQL
0 vote194 views1 answer
Mssql unique key accept nulls
SQL
0 vote122 views1 answer
Sql counter column
SQL
0 vote153 views1 answer
Sql count matching group by
SQL
1 vote112 views1 answer
Restart identity postgresql
SQL
0 vote123 views1 answer
H2 auto increment and unique
SQL
0 vote115 views1 answer
Sql developer search all packages for text
SQL
0 vote118 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
1 vote133 views1 answer
Delete specific row in sql
SQL
0 vote118 views1 answer
Sqlite select split string
SQL