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 vote333 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
0 vote346 views1 answer
Mysql isshow
SQL
12 votes340 views1 answer
Docker mysql random root password
SQL
16 votes337 views2 answers
Oracle ddl
SQL
5 votes343 views5 answers
Find max number in sql
SQL
-1 vote337 views1 answer
Search all database tables for a value sqlserver
SQL
31 votes327 views3 answers
Sql count(*)
SQL
15 votes328 views6 answers
Drop foreign key mysql
SQL
2 votes379 views1 answer
Python sql
SQL
0 vote321 views1 answer
Select only one row sql
SQL