Author : Benjamin Rosenzweig
Publisher : Prentice Hall Professional
Page : 688 pages
File Size : 22,88 MB
Release : 2003
Category : Computers
ISBN : 9780130473202
The authors teach all the Oracle PL/SQL skills readers need, through hands-on, real-world labs, exercises, projects, and a great Web-based training site! Coverage includes every key Oracle PL/SQL concept, including: the basics of structured programming; PL/SQL structure and syntax; iterative control; scoping and anchored datatypes.
Author : Alice Rischert
Publisher : Prentice Hall Professional
Page : 886 pages
File Size : 38,53 MB
Release : 2003
Category : Computers
ISBN : 9780131002777
In this unique workbook pedagogy with hands-on exercises, programming projects and a free Web-based training module, the author covers every key Oracle SQL concept: SQL*Plus, DDL, DML, DQL, the Oracle Data Dictionary, and more!
Author : Baman Motivala
Publisher : Prentice Hall
Page : 0 pages
File Size : 17,1 MB
Release : 2000
Category : Client/server computing
ISBN : 9780130158086
Motivala shows readers how to make the most of Form Builder and its components, build Forms and Forms Objects, create high-productivity layouts, and more. Next, users will master more sophisticated techniques, including Forms Triggers, multiform applications, alerts, and menus. Finally, they will master the fundamentals of Oracle Reports and discover how to do call reports directly from Oracle Forms.
Author : Steven Feuerstein
Publisher : "O'Reilly Media, Inc."
Page : 1028 pages
File Size : 42,59 MB
Release : 2002
Category : Computers
ISBN : 9780596003814
The authors have revised and updated this bestseller to include both the Oracle8i and new Oracle9i Internet-savvy database products.
Author : Susan Boardman
Publisher : Prentice Hall Professional
Page : 774 pages
File Size : 30,42 MB
Release : 2003
Category : Computers
ISBN : 9780130477316
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.
Author : Benjamin Rosenzweig
Publisher : Prentice Hall Professional
Page : 766 pages
File Size : 18,46 MB
Release : 2004
Category : Computers
ISBN : 9780131172616
Start developing applications with Oracle PL/SQL-fast! This integrated book-and-Web learning solution teaches all the Oracle PL/SQL skills you need, hands on, through real-world labs, extensive examples, exercises, projects, and a complete Web-based training site. Oracle PL/SQL by Example, Third Edition covers Oracle 10G and all the fundamentals: Master PL/SQL syntax, iterative and conditional control, scoping, anchored datatypes, cursors, triggers, security, tables, procedures, functions, packages and Oracle-supplied packages-plus powerful new techniques for working with exceptions, cursors, collections, and records. Your free Web-based training module includes a Virtual Study Lounge where you can interact with other learners, work on new projects, and get updates! Totally integrated with a FREE, state-of-the-art Oracle 10G learning Web site! Every Prentice Hall Oracle Interactive Workbook is fully integrated with its own exclusive Web site, giving you all this and more: "Test Your Thinking" project solutions and detailed explanations Additional self-review exercises with instant feedback and explanations An exclusive Virtual Study Lounge where you can interact with other students! Just the facts! No endless, boring discussions here! You'll learn hands on, through practical exercises, self-review questions, and real-world answers. Exclusive "Test Your Thinking" projects guarantee you'll go beyond rote knowledge to really master the subject! It's an integrated learning system that's proven to work!
Author : Steven Feuerstein
Publisher : "O'Reilly Media, Inc."
Page : 592 pages
File Size : 44,59 MB
Release : 2000
Category : Computers
ISBN : 1565926749
Written by one of the world's leading experts on the Oracle PL/SQL language, this text offers extensive exercises in all skill levels covering major features of the language. Also provides a primer to the PL/SQL language.
Author : Bert Scalzo
Publisher : Prentice Hall Professional
Page : 236 pages
File Size : 35,89 MB
Release : 2003
Category : Computers
ISBN : 9780130325846
The ultimate reference guide to successful implementation of star schemas within Oracle data warehouses, this edition also covers Oracle 8i and Oracle 9i with real-world examples, sample code and benchmarks to illustrate key concepts.
Author : Benjamin Rosenzweig
Publisher : Pearson Education
Page : 823 pages
File Size : 23,32 MB
Release : 2008-08-15
Category : Computers
ISBN : 0137151705
This integrated learning solution teaches all the Oracle PL/SQL skills you need, hands-on, through real-world labs, extensive examples, exercises, and projects! Completely updated for Oracle 11g, Oracle PL/SQL by Example , Fourth Edition covers all the fundamentals, from PL/SQL syntax and program control through packages and Oracle 11g’s significantly improved triggers. One step at a time, you’ll walk through every key task, discovering the most important PL/SQL programming techniques on your own. Building on your hands-on learning, the authors share solutions that offer deeper insights and proven best practices. End-of-chapter projects bring together all the techniques you’ve learned, strengthening your understanding through real-world practice. This book’s approach fully reflects the authors’ award-winning experience teaching PL/SQL programming to professionals at Columbia University. New database developers and DBAs can use its step-by-step instructions to get productive fast; experienced PL/SQL programmers can use this book as a practical solutions reference. Coverage includes • Mastering basic PL/SQL concepts and general programming language fundamentals, and understanding SQL’s role in PL/SQL • Using conditional and iterative program control techniques, including the new CONTINUE and CONTINUE WHEN statements • Efficiently handling errors and exceptions • Working with cursors and triggers, including Oracle 11g’s powerful new compound triggers • Using stored procedures, functions, and packages to write modular code that other programs can execute • Working with collections, object-relational features, native dynamic SQL, bulk SQL, and other advanced PL/SQL capabilities • Handy reference appendices: PL/SQL formatting guide, sample database schema, ANSI SQL standards reference, and more
Author : Guy Harrison
Publisher : Pearson Education
Page : 934 pages
File Size : 44,44 MB
Release : 2009-10-09
Category : Computers
ISBN : 0137000502
Oracle Performance Survival Guide A Systematic Approach to Database Optimization The fast, complete, start-to-finish guide to optimizing Oracle performance Oracle Performance Survival Guide offers a structured, systematic, start-to-finish methodology for optimizing Oracle performance as efficiently as possible. Leading Oracle expert Guy Harrison shows how to maximize your tuning investment by focusing on causes rather than symptoms, and by quickly identifying the areas that deliver the greatest “bang for the buck.” Writing for DBAs and developers with all levels of experience, Harrison covers every area of Oracle performance management, from application design through SQL tuning, contention management through memory and physical IO management. He also presents up-to-the-minute guidance for optimizing the performance of the Oracle 11g Release 2. You’ll start by mastering Oracle structured performance tuning principles and tools, including techniques for tracing and monitoring Oracle execution. Harrison illuminates the interaction between applications and databases, guides you through choosing tuning tools, and introduces upfront design techniques that lead to higher-performance applications. He also presents a collection of downloadable scripts for reporting on all aspects of database performance. Coverage includes • “Tuning by layers,” the most effective, highest-value approach to Oracle performance optimization • Making the most of Oracle’s core tools for tracing, monitoring, and diagnosing performance • Highly efficient database logical and physical design, indexing, transaction design, and API use • SQL and PL/SQL tuning, including the use of parallel SQL techniques • Minimizing contention for locks, latches, shared memory, and other database resources • Optimizing memory and physical disk IO • Tuning Real Application Cluster (RAC) databases guyharrison.net informit.com/ph
