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 ...
Read More
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.
Read Less
Add this copy of Oracle 12C New Features: SQL, PL/SQL & Administration to cart. $23.79, new condition, Sold by GreatBookPrices rated 4.0 out of 5 stars, ships from Columbia, MD, UNITED STATES, published 2017 by Createspace Independent Publishing Platform.
Choose your shipping method in Checkout. Costs may vary based on destination.
Seller's Description:
New. Trade paperback (US). Glued binding. 78 p. In Stock. 100% Money Back Guarantee. Brand New, Perfect Condition, allow 4-14 business days for standard shipping. To Alaska, Hawaii, U.S. protectorate, P.O. box, and APO/FPO addresses allow 4-28 business days for Standard shipping. No expedited shipping. All orders placed with expedited shipping will be cancelled. Over 3, 000, 000 happy customers.
Add this copy of Oracle 12C New Features: SQL, PL/SQL & Administration to cart. $24.29, new condition, Sold by Ingram Customer Returns Center rated 5.0 out of 5 stars, ships from NV, USA, published 2017 by Createspace Independent Publishing Platform.
Add this copy of Oracle 12c New Features: Sql, Pl/Sql & Administration to cart. $46.01, good condition, Sold by Bonita rated 4.0 out of 5 stars, ships from Santa Clarita, CA, UNITED STATES, published 2017 by CreateSpace Independent Publis.
