This volume will take you from novice to master, covering not only how to use SQL but also the Oracle extensions to SQL. The examples feature the sample schemas available with Oracle Database 10g, and free code will be available for download.
If you work with Oracle, then you don't need to be told that the data dictionary is large and complex, and grows larger with each new Oracle release. It's one of the basic elements of the Oracle database you interact with regularly, but the sheer number of tables and views makes it difficult to remember which view you need, much less the name of the specific column. Want to make it simpler? The "Oracle Data Dictionary Pocket Reference" puts all the information you need right at your fingertips. Its handy and compact format lets you locate the table and view you need effortlessly without stopping to interrupt your work "Oracle Data Dictionary Pocket Reference" gives DBAs and developers at any level quick and easy access to the data dictionary in Oracle's latest database, Oracle9i. This pocket-sized book provides a complete list of the most commonly used tables and views in the Oracle9i data dictionary, intelligently arranged for quick reference. It also includes column names and descriptions for each of the tables and views, as well as helpful tips, warnings, and usage examples. O'Reilly's Pocket References have become a favorite among developers and database administrators everywhere. By providing a wealth of important details in a concise, well-organized format, these handy books deliver just what you need to complete the task at hand. When you've reached a sticking point in your work and want to check your facts quickly, the "Oracle Data Dictionary Pocket Reference" is the book to have close by.
En este libro se presenta un análisis bastante completo de la base de datos Oracle 9i en su versión más extensa (Oracle 9i Enterprise Edition). Se comienza tratando la instalación del programa, la introduccion del trabajo en el entorno SQL*Plus y el desarrollo amplio del modelo entidad-relacion a traves de Oracle 9i SQL, que se trata detadallamente. Asimismo, se desarrollan de forma exhaustiva todas las tareas relativas a la administracion de la base de datos, incluyendo la administracion avanzada con Oracle Enterprise Manager, la administracion de la seguridad, el ajuste de las bases de datos, las tareas de auditoria y la migracion de datos. Cada capitulo se ilustra con un numero importante de ejercicios practicos que completan los conceptos teoricos y hacen referencia a bases de datos ejemplo que son construidas en el propio libro, asi como a la que instala por defecto Oracle 9i y que siempre esta disponible para los usuarios, por lo que no es necesario acudir a ficheros externos ni a otro tipo de informacion adicional.
Gracias a La biblia de Oracle8 obtendrá un conocimiento firme de Oracle y su línea completa de productos, programas y servicios para su desarrollo y administración. Mejorará sus técnicas de desarrollo en todas las areas de Oracle8, desde el diseño hasta la seguridad de las aplicaciones. Aprendera la forma de programar efectivamente SQL y PL/SQL para obtener el maximo de su base de datos Oracle. Examinara la teoria que hay detras de los VLDB, de los LOB de Oracle8 del almacenamiento de datos y de los mercados de datos, en definitiva, hagase un experto usuario y programador de Oracle8 gracias a este libro.Utilice Designer/2000 para diseñar todos los aspectos de su sistema, decida que servidor es el que se adapta a sus necesidades, Personal Oracle, Workgroup, Oracle8 o Enterprise, use SQL Plus, Enterprise Manager y herramientas de terceros para trabajar con los datos de forma interactiva, utilice Developer/2000 para crear objetos de aplicacion tales como formularios e informes, construya cartuchos del lado cliente, de base de datos y del lado servidor para desarrollar bases de datos distribuidas para la Web. El CD-ROM incluye el codigo fuente y ejemplos del autor del libro y software de evaluacion de terceros.Septiembre 1998
Oracle development tools come and go, but one of the few constants in the Oracle database environment is the PL/SQL programming language, which has been around for more than a decade. As Oracle's premier tool for building store procedures, PL/SQL uniquely supplements the standard relational database language, SQL, with the features needed to build real-world applications. Among our best-selling books on PL/SQL, Learning Oracle PL/SQL is the first one a newcomer to the language will want to read. Beginning with a discussion of what PL/SQL is and what it's good for, this book then presents language features, one at a time, in an engaging and readable way. A consistent and understandable example application--the development of a library's electronic catalog system--runs through the chapters. Topics include: Why use PL/SQL at all? Fundamental components of the language Fast ways to read and write Oracle data Organizing code for reusability Using PL/SQL to generate web-based applications Making sure your PL/SQL application is secure against hackers Benefits of using third-party developer tools Interacting with the internet (e.g., sending email from the database) New PL/SQL features in Oracle9i. Learning Oracle PL/SQL introduces PL/SQL in a way that's useful to a variety of audiences: beginning programmers, new Oracle database administrators, and developers familiar with other databases who now need to learn Oracle.
