A proven best-seller by the most recognized Oracle expert in the world.
The best Oracle book ever written. It defines what Oracle really is, and why it is so powerful.
Inspired by the thousands of questions Tom has answered on his site. It tackles the problems that developers and DBAs struggle with every day.
Provides everything you need to know to program correctly with the database and exploit its feature-set effectively.
Thomas Kyte has a simple philosophy: You can treat Oracle as a black box and shove data inside of it, or you can learn how Oracle works and exploit it as a powerful computing environment. If you choose the latter, you will see there are few information management problems you cannot solve quickly and elegantly.
Kyte has selected the most important features and techniques to discuss in Expert One-on-One Oracle, which he teaches in a proof-by-example manner. He discusses available features, implementing software using these features, and avoiding potential pitfalls.
Inhaltsverzeichnis
Setting Up. - Developing Successful Oracle Applications. - Architecture. - Locking and Concurrency. - Transactions. - Redo and Rollback. - Database Tables. - Indexes. - Import and Export. - Data Loading. - Tuning Strategies and Tools. - Optimizer Plan Stability. - Analytic Functions. - Materialized Views. - Partitioning. - Autonomous Transactions. - Dynamic SQL. - interMedia. - C-Based External Procedures. - Java Stored Procedures. - Using Object Relational Features. - Fine Grained Access Control. - n-Tier Authentication. - Invoker and Definer Rights.