Breaking News: Grepper is joining You.com. Read the official announcement!

partitioning in oracle-base

Saitama answered on October 7, 2020 Popularity 5/10 Helpfulness 1/10

answer partitioning in oracle-base

partitioning in oracle-base

Comment

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);

Popularity 5/10 Helpfulness 1/10 Language sql

Source: oracle-base.com

Tags: partitioning sql

Link to this answer
Share Copy Link

Contributed on Oct 07 2020

Saitama

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

partitioning in oracle-base

Contents

More Related Answers

partitioning in oracle-base

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.