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 vote134 views1 answer
Mysql extract day from date leading zero
SQL
1 vote104 views1 answer
Clear screen command in psql
SQL
1 vote119 views1 answer
Sql server update column based on another table
SQL
2 votes107 views3 answers
3 days back in sql server
SQL
31 votes112 views3 answers
Sql count
SQL
0 vote124 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
1 vote108 views1 answer
MySQL AND Operator
SQL
0 vote135 views1 answer
Procedures sql insert mysql
SQL
0 vote123 views1 answer
Sql constarint
SQL
0 vote109 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL