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 vote256 views1 answer
Find most frequent value in SQL column
SQL
0 vote252 views1 answer
Setting default value for Boolean data type in SQL
SQL
1 vote345 views2 answers
Coderbyte sql solutions
SQL
0 vote265 views1 answer
Get id if is not equal in certain table
SQL
3 votes262 views3 answers
List columns in table postgres
SQL
0 vote266 views1 answer
Mysql coonect sample code
SQL
0 vote273 views1 answer
VSCode SQL Server Connection error
SQL
2 votes260 views1 answer
No data found oracle
SQL
1 vote257 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
25 votes270 views5 answers
Uninstall mysql ubuntu
SQL