Learning
Java.net

Learning
SQLServer
.com

Learning
C.net

Learning
VB.net

Learning
SAP.com

Oracle White
Papers &
Articles

Tech Stock
Quotes

Oracle
ITtoolbox

Free Oracle Exam Guide

Get the 1Z0-040 Oracle Database 10G New Features for Administrators Practice Exam absolutely free.

Application Developers: PL/SQL & SQL

Oracle SQL by Example, Third Edition By: Alice Rischert Crafted for hands-on learning -- and fully updated for Oracle 10g -- and tested in classrooms worldwide this book illuminates in-depth every Oracle SQL technique you'll need. From the simplest query fundamentals through the newest regular expression database enhancements, you will focus on the tasks that matter most. Hundreds of guided lab exercises will systematically strengthen your expertise in writing effective, high-performance SQL. Along the way, you will acquire an arsenal of useful Oracle SQL knowledge and techniques: an extraordinary library of solutions for your real-world challenges with Oracle SQL. Creating and using tables, views, indexes, and sequences Working in SQL*Plus and iSQL*Plus environments Oracle functions in depth -— especially number, character, date, timestamp, interval, time zone, aggregate, and analytical functions All types of joins, including equijoins, outer joins, self joins and ANSI join syntax options Every type of subquery, including correlated and scalar subqueries, set operators, hierarchical queries, flashback queries, data dictionary, object-relational features, regular expressions, and more Common pitfalls to avoid, and solutions for common mistakes Practical performance, security, and architectural solutions Insights, tips, and tricks-of-the-trade from an experienced Oracle professional For every database developer, administrator, designer or architect, regardless of experience

Oracle 9I: SQL With an Introduction to Pl/SQL By: Lannes L., Ph.D. Morris-Murphy This book not only prepares students for the first exam in both the Oracle Database Administrator (DBA) and Internet Application Developer Certification Tracks; it offers them a solid understanding of Oracle9i SQL and how to use it effectively. This textbook is not simply a study guide; it is written for individuals who have just a basic knowledge of databases and can be utilized in a course on this latest implementation of SQL from Oracle. A business case that follows the progress of an online book retailer, JustLee Books, runs through every chapter, and many of the examples in each chapter build on this case. In addition, hands-on activities at the end of each chapter, such as review questions, assignments, and a case project, help to reinforce Oracle9i SQL skills.

Oracle PL/SQL Programming, Third Edition By: Steven Feuerstein Has been an indispensable reference for both novice and experienced PL/SQL developers since its first edition. Now in its third edition, the book has been thoroughly revised and updated to include the latest Oracle releases -- Oracle8i and Oracle9i -- the "Internet databases" that communicate with other technologies, such as Java, to run powerful e-commerce applications. Oracle has made substantial changes to the PL/SQL language, and developers who want to take full advantage of its power will find the information they need in this book. Authored by renowned PL/SQL experts Steven Feuerstein and Bill Pribyl, the new edition of the book includes all PL/SQL language features up to and including Oracle 9i Release 2 (9.2). Regardless of the version you are using, from Oracle 7.3.4 to Oracle 9i, this book will answer your questions. In addition, Oracle PL/SQL Programming now contains much-requested new chapters on Oracle triggers, the internal architecture of PL/SQL in the Oracle database, and the use of PL/SQL with Java. The authors have carefully constructed each chapter of this new edition with three objectives: to help you take full advantage of PL/SQL, learn to use PL/SQL to solve your problems, and to write efficient, maintainable code.

Oracle SQL Interactive Workbook (2nd Edition) By: Alice Rischert Designed to help you master Oracle SQL quickly. through hands-on, real world labs, exercises, projects, and Web-based training site.

Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts By: John Adolph Palinski Initial chapters offer a complete introduction to the relational database environment, including a discussion of how to use the logical data model to understand the database. Oracle database objects are explored, along with uses of the Data Definition Language (DDL), the Data Control Language (DCL), and the Data Manipulation Language (DML). Later chapters offer complete coverage of the Select command used to retrieve information from the database. Also included are coverage of Oracle’s new analytic functions, a chapter on performancetuning techniqes needed for complex SQL, and a detailed overview of Oracle’s PL/SQL language.

Oracle High-Performance SQL Tuning By: Donald Burleson A comprehensive guide to tuning SQL statements for optimal execution. This expert resource explains how to view the internal execution plan of any SQL statement and change it to improve the performance of the statement. You'll get details on Oracle's optimizer modes, SQL extensions, the STATSPACK utility, and a wealth of methods for tuning Oracle SQL statements.

Oracle PL/SQL: The Complete Video Course By: Elena Silvestrova, Benjamin Rosenzweig A QuickTime video course teaching Oracle PL/SQL from basic concepts to mastery. Based on courses at Columbia University, this text and quick-time CD-ROM video package uses real-world labs, exercises, and projects to explore every aspect of Oracle PL/SQL development. Covers syntax, program control, exceptions, cursors, procedures, functions, packages, stored code, triggers, PL/SQL tables, and more.

Oracle PL/SQL Programming Developer's Workbook By: Steven Feuerstein, Andrew Odewahn A companion to Steven Feuerstein's bestselling books, Oracle PL/SQL Programming (considered the bible for PL/SQL developers), Oracle Built-in Packages, and Advanced Oracle PL/SQL: Programming with Packages. The workbook provides a carefully constructed set of exercises that test PL/SQL developers' language skills and help them become better programmers.

Oracle8 PL/SQL Programming By: Scott Urman, Wendy Rinaldi (Editor) Details all the important features of PL/SQL 8.0 that are essential to Oracle developers, experienced programmers, and Oracle database administrators. Covers advanced features such as large objects and abstract data types. Includes demo versions of Platinum's SQL-Station and Oracle's Web Server.

Oracle PL/SQL Programming By: Steven Feuerstein, Bill Pribyl, Debby Russell Includes chapters on Oracle8 object types, object views, collections, external procedures, and large object types and functions. It also covers new strategies for tuning, tracing, and debugging PL/SQL programs and offers many new programs on the accompanying disk.

Oracle Built-In Packages By: Steven Feuerstein, Charles Dye, John Beresniewicz Pulls together information about how to use the call interface to the built-ins (which dramatically extent the power of the PL/SQL language), explains the implementation details, and supplies extensive examples on using the built-in packages effectively. It includes coverage of Oracle's distributed database packages, as well as the newest Oracle8 packages.

Oracle PL/SQL Programming: Guide to Oracle8i Feature By: Steven Feuerstein Gives a jump start on the new PL/SQL features of Oracle8i (Oracle's revolutionary "Internet database"). It covers autonomous transactions, invoker rights, native dynamic SQL, bulk binds and collects, system-level database triggers, new built-in packages, fine-grained access control, calling Java methods from within PL/SQL, and much more. Includes a diskette containing 100 files of reusable source code and examples.

Advanced Oracle PL/SQL: Programming With Packages By: Scott Urman, Wendy Rinaldi (Editor) Looks thoroughly at one especially advanced and powerful part of the PL/SQL language -- the package. The use of packages can dramatically improve your programming productivity and code quality, while preparing you for object-oriented development in Oracle technology.

Oracle PL/SQL Tips & Techniques By: Joseph C. Trezzo, Bradley D. Brown, Richard J. Niemiec, Brad Brown, Rich Niemiec An all-encompassing PL/SQL best practices and tips and techniques repository. Includes PL/SQL Development foundation, DBA related PL/SQL issues, PL/SQL security, Oracle supplied packages, PL/SQL data dictionary scripts, PL/SQL role in Web Applications, new PL/SQL related features, and PL/SQL quick reference.

Oracle SQL & PL/SQL Annotated Archives By: Kevin Loney, Rachel Carmichael A topical collection of SQL & PL/SQL scripts for Oracle7 and Oracle8. Starts with Oracle8-specific scripts that include warning indicators for password expirations, scripts for determining value distributions across table and index partitions, and others. Moves to scripts for collecting statistics and managing the System Global Area, monitoring transactions, diagnostic utilities to analyze data definition and similar scripts for managing objects and space, and diagnostic and utility scripts for managing users and some general database scripts.

Building Intelligent Databases With Oracle Pl/SQL, Triggers, and Stored Procedures (2nd Edition) By: Kevin T. Owens Focuses on how to develop procedural constraints through triggers and stored procedures, integrating them with other enforcement methods to achieve a maintainable system which is capable of evolving as needed. Topics include testing, configuration management, and version control, with programming and code examples.

© 2000-2009, Krislyn Technologies LLC.