This book covers three aspects 1: Interoperability among database versions 2: Integration of related concepts for performance 3: Creation of Golden Diary in a nutshell by practical examples These intentions have been arisen based on the burning need of database users I have come across throughout my career with roles like PL/SQL developers, Database Administrators, Designers, Data analysts, Performance tuning analysts, Architects, Students, Professors, Interviewees and any DBMS enthusiast or aspirant for oracle certification. Some of these had extensive experience in what they do and have...

This book dealt with below intention: Improve performance of oracle code by showcasing all possible alternative concepts present in database This intention have arisen based on the burning need of database users I have come across throughout my career with roles like PL/SQL developers, Database Administrators, Designers, Data analysts, Performance tuning analysts, Architects, Students, Professors, Interviewees and any DBMS enthusiast or aspirant for oracle certification. Some of these had extensive experience in what they do and have influenced me writing this book. This book will teach you...

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...