Lately I wrote a post about 12.2 new features. In the post I didn’t list sharding (probably one of the biggest features in this version), as I wanted to dedicate
Lately I wrote a post about 12.2 new features. In the post I didn’t list sharding (probably one of the biggest features in this version), as I wanted to dedicate
As you know, Oracle Open World is over (for me at least), and one of the major topics there was Oracle 12cR2 (or 12.2). It looks like a really cool
Being in North America (the English speaking side), made me understand that many people are not aware (and don’t actually care) about character sets too much. Everything supports English, and
If you have read my previous post about this (if not, you can find it here), you know that I found a cardinality issue with 12c top-N queries (or row
While writing the last post about paging queries (can be found here) I checked the 12c new top-n feature.The idea behind this feature is to tell Oracle, in native SQL
In the past few months I had several occasions to use the “rownum” pseudo-column to page a query result set. As we know, a query returns a result set, which
Database Identifiers are basically names of objects in the database, like tables, indexes, etc. There are restrictions about identifiers in Oracle, they can be up to 30 characters, must begin
Constraint are objects we all know, we use them a lot when creating tables and they allow us to: Keep data integrity at the table level, like disallow null values