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 . This chapter contains descriptions of the features that are available in oracle database 12crelease 1 12102 this chapter contains the following sections section 11 advanced index compression section 12 approximate count distinct section 13 attribute clustering. Oracle database 12c new features freeman robert isbn 9780071799317 kostenloser versand fur alle bucher mit versand und verkauf duch amazon. Following are some nice oracle 12c database new features online data file movement this feature helps you to rename move active datafile online it is very useful for database reorganization or any disk movement for managing space online table partition or sub partition movement advertisement now in oracle database 12c you can move table partition or sub partition online while