Introduction
Oracle Database is a commercial database with the highest market share. With the intelligence of Oracle management tools, such as Oracle em provides powerful management and tuning functions, oracle DBA management tends to be simplified gradually. As a result, the number of Oracle developers in China has increased significantly, and the number of Oracle developers is also growing.
A good Oracle Developer not only needs to know some basic syntax and common usage, but also needs to know when to use, how to use it, how to avoid misunderstandings, and how to write high-quality Code. This book is intended for users who have experience using Oracle or other databases. It focuses on the ideas and skills for efficient development by taking advantage of the features of Oracle, helping readers quickly master the advanced Oracle development technology.
This book covers important knowledge points necessary for Oracle development: database Programming specifications, common Oracle development tools and usage, merge method, mysterious null and annoying char, extended group by, Oracle automatic type conversion, Oracle analysis functions, Oracle hierarchical query, 11 new Features of G R2 include recursive with programming and dynamic SQL expansion. There are also a large number of cases: Where in list problem analysis, database Design and big data processing, data review, number segment selection and application, analysis of SQL Execution Plan concerns, exploration of Oracle development misunderstandings, improvement of PL/SQL development performance, Pipeline Function Learning and practical application clever Use of the lock feature to avoid repeated startup of the same ProgramAnd impossible tasks? Beyond oracle.
The authors of this book have many years of practical experience in Oracle development and management. They hope to share their experiences and lessons to analyze and solve problems and explore how to use relevant technologies to solve specific needs. I hope that after reading this book, readers will be well enlightened and can greatly improve their Oracle database development capabilities!
