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 vote373 views1 answer
Capabilities of sql select statements
SQL
1 vote389 views2 answers
Sql insert timestamp
SQL
0 vote353 views1 answer
Get relation data in mysql using query to excel
SQL
1 vote346 views2 answers
Check if word is in column sql
SQL
0 vote375 views1 answer
How to generate ids in sql
SQL
0 vote361 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
0 vote340 views2 answers
T SQl Checking Your Username
SQL
-1 vote354 views1 answer
Mysql change database charset and collation
SQL
1 vote342 views1 answer
Error code 1055
SQL
13 votes369 views2 answers
Sql join 3 tables
SQL