By applying such collations to sql operations an application can perform string comparisons and matching in a case insensitive way independent of the language of the data with the new oracle database 12 c release 2 122 ability to declare collations for columns you can declare a column to always be compared in a case insensitive way the column collation if not specified explicitly is inherited from a table default collation which in turn is inherited from a schema default collation. 1 oracle database 12 c release 1 12102 new features 11 advanced index compression advanced index compression works well on all supported indexes including those indexes 12 approximate count distinct the new and optimized sql function approx count distinct provides approximate . Oracle 12c new features in my previous article i have given different features of oracle 18c as well as oracle 11g vs oracle 12c in this article i would like to give you oracle 12c new featuresi would also like to give you oracle 12c new features with real life examplesthese oracle 12c new features are really helpful for users to achieve the business requirement easily. Oracle 12c last login time for non sys users oracle 12c introduced a new very useful security feature to store and display the last login information for non sys users logging in via sqlplus the last login time is displayed in the banner by default when we log into the database using sqlplus in 12c
How it works:
1. Register Trial Account.
2. Download The Books as you like ( Personal use )