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 vote277 views1 answer
Sql alchemy with azuresql server
SQL
1 vote280 views1 answer
Oracle undo usage per session
SQL
0 vote255 views1 answer
Django mysqlclient connection string
SQL
4 votes271 views1 answer
Sql any
SQL
0 vote278 views4 answers
Convert databse to achieve log mode oracle
SQL
0 vote367 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
0 vote269 views1 answer
Difference between db.query and db.execute
SQL
1 vote288 views1 answer
Random name function in mysql for nvarchar
SQL
0 vote298 views1 answer
Create user faunadb
SQL
0 vote267 views1 answer
Excute raw query
SQL