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 vote271 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
4 votes293 views1 answer
Datepart postgres
SQL
2 votes281 views1 answer
Sql server find table name
SQL
0 vote320 views1 answer
Oracle insert single quote in string
SQL
0 vote280 views1 answer
Acual month sql
SQL
0 vote272 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
0 vote295 views1 answer
Mariadb date equals to current_date plus days
SQL
3 votes273 views1 answer
Oracle user quota unlimited
SQL
0 vote301 views1 answer
Tsql delete all rows
SQL
1 vote266 views1 answer
Mysql collation
SQL