Oracle 12C New Features: SQL, PL/SQL & Administration - Couverture souple

Chowdhury, Asim

 
9781543265934: Oracle 12C New Features: SQL, PL/SQL & Administration
Couverture souple
ISBN 10 : 1543265936 ISBN 13 : 9781543265934
Editeur : CreateSpace Independent Publishing Platform, 2017

Synopsis

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 in conditional compilation, granting role to stored subprogram instead of user etc. For 12c ADMINISTRATION it has expanded the following features: • Adaptive query optimization and online stats gathering, faster online table column addition, DDL LOGGING, adding multiple new partition, global temporary table enhancement, stats gathering improvement, heat map, improvement in auditing using flashback, improvement in tracking security sensitive tables, import & export of version history, free flashback archive and optimize option, Multitenant container database with Pluggable database option etc. While explaining only 12c new features, I have tried to provide alternative approach prior to 12c also so that the reader can understand the concept with an ease. Hope this 75 pages book will help immensely to learn all the 12c new features and help the reader to use the features in real life confidently.

Les informations fournies dans la section « Synopsis » peuvent faire référence à une autre édition de ce titre.

Présentation de l'éditeur

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 in conditional compilation, granting role to stored subprogram instead of user etc. For 12c ADMINISTRATION it has expanded the following features: · Adaptive query optimization and online stats gathering, faster online table column addition, DDL LOGGING, adding multiple new partition, global temporary table enhancement, stats gathering improvement, heat map, improvement in auditing using flashback, improvement in tracking security sensitive tables, import & export of version history, free flashback archive and optimize option, Multitenant container database with Pluggable database option etc. While explaining only 12c new features, I have tried to provide alternative approach prior to 12c also so that the reader can understand the concept with an ease. Hope this 75 pages book will help immensely to learn all the 12c new features and help the reader to use the features in real life confidently.

Les informations fournies dans la section « A propos du livre » peuvent faire référence à une autre édition de ce titre.

Éditeur
CreateSpace Independent Publishing Platform
Date d'édition
2017
Langue
anglais
ISBN 10 
1543265936
ISBN 13 
9781543265934
Reliure
Broché
Nombre de pages
78
Coordonnées du fabricant
non disponible
Personne responsable
non disponible