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 vote327 views1 answer
How to start my sql server on mac
SQL
1 vote313 views1 answer
Get last week data in mysql
SQL
-1 vote321 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
33 votes324 views6 answers
Change column name in mysql
SQL
1 vote325 views1 answer
Sql order by where condition
SQL
-1 vote332 views4 answers
Postgres between dates
SQL
0 vote319 views2 answers
Athena drop partition
SQL
0 vote348 views1 answer
How to set up an anonymous function to variable in swift
SQL
0 vote333 views1 answer
Top 3 salary in sql
SQL
0 vote326 views1 answer
Sql shell psql cannot enter password
SQL