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 vote171 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
0 vote179 views1 answer
SQL FROM-Klausel
SQL
0 vote199 views1 answer
.sql File Run in PSQL
SQL
6 votes167 views1 answer
Phpmyadmin password root
SQL
1 vote215 views1 answer
Check if mysql is installed
SQL
0 vote179 views1 answer
C# get sql min date
SQL
0 vote179 views1 answer
Sql query to get contact form 7 fields
SQL
2 votes183 views1 answer
SQL IF ELSE
SQL
0 vote176 views1 answer
Sql where part of string match
SQL
1 vote264 views1 answer
Sql server delete top 1000
SQL