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 vote339 views1 answer
How to reset autoincrement in sqlite java
SQL
0 vote599 views1 answer
How to connect .sql data set to powerbi
SQL
0 vote358 views1 answer
Parent and child link in mysql
SQL
0 vote294 views1 answer
Acual month sql
SQL
0 vote319 views1 answer
No query unable to fetch row sqlite
SQL
-1 vote349 views1 answer
Add 10 to all numbers in a column sql
SQL
1 vote300 views1 answer
How to drop function in sql
SQL
0 vote336 views1 answer
Prisma transaction
SQL
1 vote290 views1 answer
Mysql pretty date format
SQL
2 votes311 views1 answer
When matched in sql server
SQL