Chris SaxoninOracle DevelopersPL/SQL Code Coverage: 12 Things Developers Will Love About Oracle Database 12c Release 2 Part 12We’ve covered a lot of new functionality in this series. Some if it you’ll use straight away. Other bits you’ll wait a while.Oct 25, 20171Oct 25, 20171
Chris SaxoninOracle DevelopersMark Old PL/SQL Code as "Not For Use":12 Things Developers Will Love About Oracle Database 12c…Times change. New code quickly becomes legacy code. And legacy code is often superseded by better, faster code. So you deprecate the old…Oct 18, 2017Oct 18, 2017
Chris SaxoninOracle DevelopersAutomatic List Partitioning: 12 Things Developers Will Love About Oracle Database 12c Release 2…List partitions are great when you have a column with a specific set of values you want to carve into separate partitions. Things like…Oct 11, 20171Oct 11, 20171
Chris SaxoninOracle DevelopersSingle Statement Table Partitioning: 12 Things Developers Will Love About Oracle Database 12c…It’s a question that frequently comes up on Ask TOM:Oct 4, 20171Oct 4, 20171
Chris SaxoninOracle DevelopersEasier, Better, Faster JSON: 12 Things Developers Will Love About Oracle Database 12c Release 2…12.1.0.2 brought JSON support to Oracle Database. This helped you work with JSON documents stored in clobs or varchar2s.Nov 10, 2016Nov 10, 2016
Chris SaxoninOracle DevelopersPL/SQL Constants for Data Type Lengths: 12 Things Developers Will Love About Oracle Database 12c…In part 2 of this series we saw that you can now create objects with names 128 bytes long. I know some of you are desperate to…Nov 10, 2016Nov 10, 2016
Chris SaxoninOracle DevelopersVerify Data Type Conversions: 12 Things Developers Will Love About Oracle Database 12c Release 2…It’s one of those all too common problems. Validating a date is indeed a date.Nov 10, 2016Nov 10, 2016
Chris SaxoninOracle DevelopersImproved Listagg on Overflooooow: 12 Things Developers Will Love About Oracle Database 12c Release…We’ve seen how longer object names can cause problems with variable declarations. But this can also bring more subtle issues. For example…Nov 10, 2016Nov 10, 2016
Chris SaxoninOracle DevelopersLoooooong Names: 12 Things Developers Will Love About Oracle Database 12c Release 2 Part 2Oracle Database handles cache invalidation for you. So as a developer you don’t have to worry about this.Nov 10, 2016Nov 10, 2016
Chris SaxoninOracle DevelopersLightning Fast SQL with Real Time Materialized Views: 12 Things Developers Will Love About Oracle…Materialized views (MVs) can give amazing performance boost. Once you create one based on your query, Oracle can get the results direct…Nov 10, 2016Nov 10, 2016