Partitioning external tables in 12.2
One of the new features in Oracle 12.2 is partitioning of external tables – a quite useful feature if you have multiple identical files of data, for example from multiple sources. But how can you partition external files, you ask? Well, you don’t partition the…
Collation in 12cR2 – when AA equals Å (or not?)
Collation in Oracle 12cR2 gives some more finegrained possibilities for setting up how your data is to sorted and compared linguistically. A lot we could do before with NLS_SORT and NLS_COMP and the likes, but the collation features can both be simpler to use as…
String to DATE conversion and validation in 12.2
A new little feature in Oracle Database 12.2 is, that you can convert strings to dates without worrying about exception handling. (That goes also for converting to numbers or timestamps or other datatypes, but here I’ll concentrate on dates.) It’s just one of a ton…
OTN Appreciation Day : GeoJSON and SDO_GEOMETRY marriage in Oracle 12.2
The native JSON functionality in Oracle Database version 12.2 has evolved quite a bit since the JSON functions first appeared in Oracle Database version 12.1.0.2. Just one example is JSON_TABLE can be used as a bridge between the open standard GeoJSON format and the database…