Gives background in Oracle's implementation of the SQL language. Each chapter is divided into labs, with objectives, examples, and exercises on specific tasks and questions that are designed to help readers discover important aspects of the SQL language. Exercises build knowledge step by step by introducing relational database concepts, the SQL*Plus environment, and the SQL language. Labs also include explained answers, multiple-choice review questions, and critical thinking questions.

This pocket reference provides quick reference information that will help you use SQL*Plus, Oracle's interactive query tool. It summarizes all of the SQL*Plus syntax, including the syntax for new Oracle8i release 8.1.6 features. SQL*Plus is available at every Oracle site--from the largest data warehouse to the smallest single-user system--and it's a critical tool for virtually every Oracle user. Despite its wide use, few developers and DBAs know how powerful a tool SQL*Plus can be. This book b oils down the most vital information from Gennick's best-selling book, Oracle SQL*Plus: The Definitive Guide, into an accessible summary. It concisely describes interacting with SQL*Plus, selecting data, formatting reports with SQL*Plus, and tuning SQL queries. It also contains quick references to the SQL*Plus commands and format elements.

Prepares students for the first exam in both the Oracle DBA and Internet Application Developer Certification Tracks, and offers a solid general understanding of Oracle9i SQL.

"Oracle9i PL/SQL: A Developer's Guide" is intended both for intermediate-level Oracle developers who are designing or coding applications in SQL and PL/SQL and for advanced PL/SQL programmers who need to learn new PL/SQL 9i features. In addition to providing developers with detailed coverage of the PL/SQL 9i language itself, author Bulusu Lakshman covers the techniques of using PL/SQL 9i for server-side applications and provides the methodology for implementing robust applications. Lakshman also mentors developers in implementing effective techniques for real-world and code-centric Oracle applications that, in the long run, will save them time and energy. "Oracle9i PL/SQL: A Developer's Guide" is a solid source for the development of Oracle9i PLSQL applications. Developers incorporating these technologies into new applications and those migrating from earlier versions will both find Lakshman's expert treatment of the topic beneficial. Bulusu Lakshman is an experienced Oracle develope r with more than 10 years of software design and development experience using Oracle and its related tools, including PL/SQL and Java. He's the author of "Oracle Developer Forms Techniques" and "Oracle and Java Development", both of which have been well received. He also holds an Oracle Master credential from the Oracle Corporation, is an Oracle Certified Professional (OCP) application developer, and is a double honors graduate in computer science and engineering and mathematics. He has presente d at numerous international and national conferences on Oracle and its tools, and published articles in various technical magazines and journals. Lakshman is currently employed by Compunnel Software Group Inc., a leading technical consulting firm based in New Jersey.

The Tool for Oracle Application Developers (TOAD) is a popular graphical user interface for the Oracle database that allows programmers to build, test, debug, an format their code within an interactive development environment. With the easy-to-use TOAD interface, changes that once took hours can be done in just minutes. TOAD allows developers to browse their database tables, procedures and object types, use code templates, and shows errors. It also simplifies database administration by providing a way for DBAs to graphically browse and change database characteristics. The only book in print for the current version of TOAD (7.4), the TOAD Pocket Reference for Oracle , provides Oracle developers and DBAs with quick reference to TOAD?s main features, shortcut keys, recommended changes to options, and productivity tips and tricks.

Introduces the basic relational database terminology and techniques for extracting information from Oracle databases. Written for beginners, the book focuses on the SQL*Plus query language and the SELECT command for querying a database. Business objects and data warehouses are briefly covered. The final three chapters overview the PL/SQL programming language. The CD-ROM contains a practice database and sample scripts

Starts with very simple Oracle SQL concepts and slowly builds into more complex query development and PL/SQL. Covers SQL as it is invoked via SQL Plus, a command-line system to launch interactive queries. Provides an appendix for UNIX users of Oracle.

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.

Like the earlier versions, this manual is intended for beginners and is not a reference book. This manual covers basics and advanced topics of SQL covering Oracle 8i version. This book is a training manual where anyone can learn SQL. This book has lot of exercises and solutions at the end of each chapter.

Oracle is the world's leading relational database. It provides a rich environment to store, handle, and extract data. When used properly, Oracle provides a solid foundation upon which to build enterprise scale applications. Mastering the Oracle database is not an overnight job. It takes time, practice, and a lot of real world experience. This book teaches you the core concepts behind using the database, shows you the tools and techniques you need to master, and gives you practical examples of p rogramming Oracle. By the time you have completed this book, you will have all the knowledge you need to use Oracle databases with confidence. You are setting out on the same journey we travelled some years ago. We know the things you are going to run into time and time again. We understand the challenges you are going to meet when you have to develop an application or administer your database. We can guarantee you that the techniques you'll learn in this book are proven and have led us through many successful implementations.

This text on the Structured Query language and the Programming Language/Structured Query Language (PL/SQL) in Oracle version 8 or higher offers step-by-step instructions supplemented by hands-on examples, exercise questions, and lab activities. Two real-life running databases are used as models to explore database issues. Early chapters cover relational concepts and database design techniques, and later chapters concentrate of the primary nonprocedural relational database language SQL and the pr ocedural language PL/SQL. Final chapters introduce the architecture and administration of Oracle 8.

SQL (Structured Query Language) is the heart of a relational database management system. It's the language used to query the database, to create new tables in the database, to update and delete database fields, and to set privileges in the database. Oracle SQL: The Essential Reference is for everyone who needs to access an Oracle database using SQL--developers, DBAs, designers, and managers. SQL is based on research dating back to the late 1960s, but its first commercial release was in the RDBMS announced by the fledgling Oracle Corporation in 1979. Since that time, every other database vendor has adopted SQL, and ANSI and the ISO have made it a standard. Although vendors diverge in their extensions to SQL, the core language is standard across vendor boundaries.

Gives background in Oracle's implementation of the SQL language. Each chapter is divided into labs, with objectives, examples, and exercises on specific tasks and questions that are designed to help readers discover important aspects of the SQL language. Exercises build knowledge step by step by introducing relational database concepts, the SQL*Plus environment, and the SQL language. Labs also include explained answers, multiple-choice review questions, and critical thinking questions. Morrison works in Internet development. Rischert is co-chair of Columbia University's Database Application Development and Design track at the Computer Technology and Application Program.

This pocket reference provides quick reference information that will help you use SQL*Plus, Oracle's interactive query tool. It summarizes all of the SQL*Plus syntax, including the syntax for new Oracle8i release 8.1.6 features. This book boils down the most vital information from Gennick's best-selling book, Oracle SQL*Plus: The Definitive Guide, into an accessible summary. It concisely describes interacting with SQL*Plus, selecting data, formatting reports with SQL*Plus, and tuning SQL queries . It also contains quick references to the SQL*Plus commands and format elements.

This book is the definitive guide to SQL*Plus. If you want to take best advantage of the power and flexibility of this popular Oracle tool, you need this book. SQL*Plus is an interactive query tool that is ubiquitous in the Oracle world. It is present in every Oracle installation and is available to almost every Oracle developer and database administrator. SQL*Plus has been shipped with Oracle since at least version 6. It continues to be supported and enhanced with each new version of Oracle, in cluding Oracle8 and Oracle8i. It is still the only widely available tool for writing SQL scripts. Despite this wide availability and usage, few developers and DBAs know how powerful SQL*Plus really is.

In Oracle SQL & PL/SQL Annotated Archives, authors Loney and Carmichael have assembled a topical collection of SQL & PL/SQL scripts for Oracle7 and Oracle8. Although this book is not by any means a tutorial for the database's programming language, even skillful database administrators can learn much from the illustrated techniques. The book begins with a chapter of Oracle8-specific scripts that include warning indicators for password expirations, scripts for determining value distributi ons across table and index partitions, and others. The rest of the chapters are devoted to particular topics. The first section addresses performance management and includes several scripts for collecting statistics and managing the System Global Area. These performance-related scripts are extremely valuable for any developer. Next comes a series of scripts related to monitoring transactions, diagnostic utilities to analyze data definition, and similar scripts for managing objects and space. Th en it's on to diagnostic and utility scripts for managing users and some general database scripts. The book wraps up with a lengthy appendix that serves as an excellent reference to the PL/SQL language. Each chapter begins with summary of its scripts, and they are also included on the CD-ROM. Explanatory text is clearly identified as annotations, but the majority of the book consists of highly technical reading. While this book does not make for a very entertaining read, it provides Oracle admi nistrators with powerful tools they can turn to in a pinch.