Oracle9i Instant PL/SQL Scripts


Book Description

This text provides readers with a comprehensive collection of SQL and PL/SQL scripts. It is organized into chapters by function and each script is fully documented with sample results shown. Readers can understand how the script works, learn to customize the script with confidence, and act properly on the script's results. Features include: scripts specifically for Oracle9i; a CD-ROM including major scripts from book; CD-icon with script name next to scripts that appear on the CD to allow for a quick search; a list of scripts and a brief description at the beginning of each chapter; and Programmer's Notes and Annotations that provide expert explanations on the scripts and how they can be customized.




Oracle PL/SQL Programming


Book Description

The authors have revised and updated this bestseller to include both the Oracle8i and new Oracle9i Internet-savvy database products.




The Oracle PL/SQL CD Bookshelf


Book Description

Readers get the complete text of the following books on CD-ROM: "Oracle PL/SQL Programming, Advanced PL/SQL Programming, Oracle Web Applications, Oracle Built-in Packages, Oracle Developer's Workbook, Oracle PL/SQL Pocket Reference, Oracle Built-ins Pocket Reference", and "Oracle PL/SQL Programming: A Guide to Oracle 8i Features".




Oracle SQL and PL/SQL Handbook


Book Description

CD-ROM contains: Practice database -- Sample scripts reference in text.




Oracle SQL and PL/SQL for Developers


Book Description

If you're developing applications that access Oracle databases, you can save time and trouble by having the database do more work for you. That's where this book comes in. It teaches you how to create effective SQL queries to retrieve and update the data in an Oracle database. It teaches you how to design and implement a database, giving you insight into performance and security issues. It teaches you how to use Oracle's procedural language, PL/SQL, to take advantage of powerful features like stored procedures, functions, and triggers. In short, it teaches you to write the kind of SQL and PL/SQL that makes you a more effective and valuable developer.




OCA / OCP: Introduction to Oracle9i SQL Study Guide


Book Description

Here's the book you need to prepare for Exam 1Z0-007: Introduction to Oracle9i: * In-depth coverage of official exam objectives * Practical information on using SQL in a real-world Oracle9i environment * Hundreds of challenging review questions, in the book and on the CD Authoritative coverage of all exam objectives, including: * Writing basic SQL SELECT statements * Restricting and sorting data * Displaying data from multiple tables * Aggregating data using group functions * Producing readable output with iSQL*Plus * Creating and managing tables * Controlling user access




Oracle Web Application Programming for PL/SQL Developers


Book Description

Learn to use Oracle 9i to build dynamic, data-driven Web sites. Get step-by-step details on creating and deploying Web applications using PL/SQL, HTML, Java, XML, WML, Peri and PHP. This book covers everything users need to know to master Web application development in an Oracle environment - using PL/SQL.




Mastering Oracle SQL


Book Description

If you work with Oracle in any capacity, whether as a Java programmer, Database Administrator, or PL/SQL programmer, chances are good that you write SQL statements to query for data within the database. 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, authors Sanjay Mishra and Alan Beaulieu share their knowledge of Oracle SQL, and show you many creative techniques that you can use to advantage in your own applications. Book jacket.




Oracle9i PL/SQL


Book Description

Developers using PL/SQL 9i as an environment for corporate applications will find detailed technical information and practical tips in Lakshman's book.




Oracle SQL


Book Description

Developers and DBAs use Oracle SQL coding on a daily basis, whether for application development, finding problems, fine-tuning solutions to those problems, or other critical DBA tasks. Oracle SQL: Jumpstart with Examples is the fastest way to get started and to quickly locate answers to common (and uncommon) questions. It includes all the basic queries: filtering, sorting, operators, conditionals, pseudocolumns, single row functions, joins, grouping and summarizing, grouping functions, subqueries, composite queries, hierarchies, flashback queries, parallel queries, expressions and regular expressions, DML, datatypes (including collections), XML in Oracle, DDL for basic database objects such as tales, views and indexes, Oracle Partitioning, security, and finally PL/SQL.* Each of the hundreds of SQL code examples was tested on a working Oracle 10g database* Invaluable everyday tool that provides an absolute plethora of properly tested examples of Oracle SQL code* Authors have four decades of commercial experience between them as developers and database administrators