Oracle 12c New Features: Sql, Pl/sql And Administration
Download Oracle 12c New Features: Sql, Pl/sql And Administration This book is for enthusiast who would like to know 12c new features with real life examples. This book expanded the following features of 12c SQL: • Row limiting clause, expand sqltext of a view, internal parser re-written sql, Invisible column, session level sequence, extended data type, truncate with cascade option, default value for NULL column, auto populate column using sequence and identity type, advanced index compression, Lateral/cross apply/outer apply, multiple index on a column, match_recognise clause for inter-rows pattern, In memory column store etc. For 12c PL/SQL it has expanded the following features: • WITH clause improvement, PRAGMA UDF, REDACTION, BEQUEATH clause, Restructuring error stack and backtrace, enhancement in PL/SQL specific data type support in NDS &binding, white listing by means of accessible by clause, Invoker right code using result_cache, improvement ...