Oracle Magazine, September/October 2017
DBA PERFORMANCE ORACLE MAGAZINE SEPTEMBER OCTOBER 2017 102 acc_ type varchar2 1 state_ code varchar2 2 acc_ balance number last_ trans_ dt date partition by range last_ trans_ dt partition p2015 values less than to_ date 01 jan 2016 partition p2016 values less than to_ date 01 jan 2017 partition p2017 values less than to_ date 01 jan 2018 insert into accounts values 1 S CT 2000 1 jul 2014 insert into accounts values 2 C CT 2000 1 jul 2015 insert into accounts values 3 S CT 2000 1 jul 2016 insert into accounts values 4 C NY 2000 1 jul 2014 insert into accounts values 5 S NY 2000 1 jul 2015 insert into accounts values 6 C NY 2000 1 jul 2016 Commit
You must have JavaScript enabled to view digital editions.