partitioning in oracle base

Solutions on MaxInterview for partitioning in oracle base by the best coders in the world

showing results for - "partitioning in oracle base"
Kirby
29 Jul 2020
1CREATE TABLE invoices
2(invoice_no    NUMBER NOT NULL,
3 invoice_date  DATE   NOT NULL,
4 comments      VARCHAR2(500))
5PARTITION BY RANGE (invoice_date)
6(PARTITION invoices_q1 VALUES LESS THAN (TO_DATE('01/04/2001', 'DD/MM/YYYY')) TABLESPACE users,
7 PARTITION invoices_q2 VALUES LESS THAN (TO_DATE('01/07/2001', 'DD/MM/YYYY')) TABLESPACE users,
8 PARTITION invoices_q3 VALUES LESS THAN (TO_DATE('01/09/2001', 'DD/MM/YYYY')) TABLESPACE users,
9 PARTITION invoices_q4 VALUES LESS THAN (TO_DATE('01/01/2002', 'DD/MM/YYYY')) TABLESPACE users);