|
Samay Live | |
|
EBooks » Oracle
Oracle Dba Made Simple: Oracle Database Administration Techniques (Oracle In-Focus Series)
Mike Ault ISBN: 097407165X Publisher: Rampant Tech Press - 2003-08   # One of the only Oracle books to focus exclusively on database programming rather than administration # Oracle owns sixty percent of the commercial database market # Provides full coverage of the latest Oracle version, 10g-including new features such as regular expressions and the MODEL SQL clause-as well as versions 8, 8i, and 9i # The authors are well-known as Oracle gurus-Greenwald is the author of Oracle in a Nutshell and the coauthor, with Stackowiak, of Oracle 9 Essentials # Shows how to use Oracle data and data structures to build robust, scalable database applications using Java, SQL, and PL/SQL  For the past ten years, O'Reilly's Oracle PL/SQL Programming has been the bestselling book on PL/SQL, Oracle's powerful procedural language. Packed with examples and helpful recommendations, the book has helped everyone--from novices to experienced developers, and from Oracle Forms developers to database administrators--make the most of PL/SQL.
The fourth edition is a comprehensive update, adding significant new content and extending coverage to include the very latest Oracle version, Oracle Database 10g Release 2. It describes such new features as the PL/SQL optimizing compiler, conditional compilation, compile-time warnings, regular expressions, set operators for nested tables, nonsequential collections in FORALL, the programmer-defined quoting mechanism, the ability to backtrace an exception to a line number, a variety of new built-in packages, and support for IEEE 754 compliant floating-point numbers.
The new edition adds brand-new chapters on security (including encryption, row-level security, fine-grained auditing, and application contexts), file, email, and web I/O (including the built-in packages DBMS_OUTPUT, UTL_FILE, UTL_MAIL, UTL_SMTP, and UTL_HTTP) and globalization and localization.
 Master all the powerful features of Oracle9 i
using the exclusive information inside this indispensable resource. This volume
explains how to implement all the components of Oracle9 i.
This is a
must-have reference for all Oracle professionals.  If you write programs to run against an Oracle database, you spend a lot of time and mental energy writing queries to return the data your programs need. Knowledge of SQL, and particularly of Oracle's implementation of SQL, is the key to writing good queries in a timely manner. In this book, the authors share their knowledge of Oracle SQL, and show you many creative techniques that you can use to advantage in your own applications.
This book shows you how to: - Leverage Oracle's vast library of built-in SQL functions
- Query time-based data, and write joins involving date and time ranges
- Use Oracle SQL's hierarchical query features to deal with data best represented in a tree format
- Use DECODE and CASE to implement conditional logic in your queries
- Use Oracle's new, analytic SQL features to write ranking queries, lag and lead queries, windowing queries, and more
- Join data from two or more tables using the newly supported SQL92 join syntax
|
| |
|
