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 vote255 views1 answer
Postgresql using reserved word as column name
SQL
0 vote274 views2 answers
How to prevent sql injection in java
SQL
1 vote291 views1 answer
Oracle show execution plan
SQL
4 votes260 views2 answers
Convert utc to est sql
SQL
0 vote271 views1 answer
Check command
SQL
0 vote254 views1 answer
Grouping by email domain mysql
SQL
0 vote261 views2 answers
Enter into postgresql database,create user and grant Access
SQL
-1 vote271 views3 answers
How to restart mysql in linux
SQL
1 vote249 views1 answer
Update and replace mysql
SQL
0 vote267 views1 answer
Sql join on a subquery
SQL