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

2 votes215 views2 answers
How to run postgresql in linux
SQL
3 votes215 views2 answers
Sql get month name
SQL
0 vote198 views1 answer
Mysql with
SQL
0 vote211 views1 answer
Procedures sql insert mysql
SQL
0 vote229 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
3 votes212 views6 answers
DB::table('users')->get();
SQL
0 vote201 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
3 votes302 views1 answer
How to get yesterday date in sql
SQL
0 vote184 views0 answer
SQL
0 vote207 views1 answer
Mysql date time string format for marshmellow field schema
SQL