Oracle Database 10g The Complete Reference

Oracle Database 10g The Complete Reference
Author: Kevin Loney
Publisher: McGraw Hill Professional
Total Pages: 1393
Release: 2004-09-28
Genre: Computers
ISBN: 0071770496
GET BOOK

Download Oracle Database 10g The Complete Reference Book in PDF, Epub and Kindle

Get a thorough understanding of Oracle Database 10g from the most comprehensive Oracle database reference on the market, published by Oracle Press. From critical architecture concepts to advanced object-oriented concepts, this powerhouse contains nearly 50 chapters designed to enlighten you. Upgrade from earlier versions, use SQL, SQL Plus, and PL/SQL. Get code examples and access popular documentation PDFs--plus a full electronic copy of the book on the included CD-ROM. Go beyond the basics and learn security, text searches, external tables, using Java in Oracle, and a great deal more.

Oracle Database 11g PL/SQL Programming

Oracle Database 11g PL/SQL Programming
Author: Michael McLaughlin
Publisher: McGraw Hill Professional
Total Pages: 865
Release: 2008-04-19
Genre: Computers
ISBN: 0071643567
GET BOOK

Download Oracle Database 11g PL/SQL Programming Book in PDF, Epub and Kindle

Design Feature-Rich PL/SQL Applications Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof security. You'll also learn how to implement C, C++, and Java procedures, Web-enable your database, cut development time, and optimize performance. Create, debug, and manage Oracle-driven PL/SQL programs Use PL/SQL structures, delimiters, operators, variables, and statements Identify and eliminate errors using PLSQL_WARNINGS and exception handlers Work with functions, procedures, packages, collections, and triggers Define and deploy varray, nested table, and associative array data types Handle external routines, object types, large objects, and secure files Communicate between parallel sessions using DBMS_ALERT and DBMS_PIPE Call external procedures through Oracle Net Services and PL/SQL wrappers Integrate internal and server-side Java class libraries using Oracle JVM Develop robust Web applications using PL/SQL Gateway and Web Toolkit

Oracle Database 11g The Complete Reference

Oracle Database 11g The Complete Reference
Author: Kevin Loney
Publisher: McGraw Hill Professional
Total Pages: 1369
Release: 2008-10-15
Genre: Computers
ISBN: 0071598766
GET BOOK

Download Oracle Database 11g The Complete Reference Book in PDF, Epub and Kindle

The Definitive Guide to Oracle Database 11g Get full details on the powerful features of Oracle Database 11g from this thoroughly updated Oracle Press guide. Oracle Database 11g: The Complete Reference explains how to use all the new features and tools, execute powerful SQL queries, construct PL/SQL and SQL*Plus statements, and work with large objects and object-relational databases. Learn how to implement the latest security measures, tune database performance, and deploy grid computing techniques. An invaluable cross-referenced appendix containing Oracle commands, keywords, features, and functions is also included. Install Oracle Database 11g or upgrade from an earlier version Create database tables, sequences, indexes, views, and user accounts Construct SQL statements, procedures, queries, and subqueries Optimize security using virtual private databases and transparent data encryption Import and export data using SQL*Loader and Oracle Data Pump Use SQL replay, change management, and result caching Avoid human errors using flashback and automatic undo management Build and tune PL/SQL triggers, functions, and packages Develop database applications using Java, JDBC, and XML Optimize availability and scalability with Oracle Real Application Clusters

Beginning Oracle Database 11g Administration

Beginning Oracle Database 11g Administration
Author: Ignatius Fernandez
Publisher: Apress
Total Pages: 448
Release: 2009-03-25
Genre: Computers
ISBN: 1430206284
GET BOOK

Download Beginning Oracle Database 11g Administration Book in PDF, Epub and Kindle

This book, written by veteran Oracle database administrator Iggy Fernandez, a regular on the Oracle conference circuit and the editor of NoCOUG Journal, is a manageable introduction to key Oracle database administration topics including planning, installation, monitoring, troubleshooting, maintenance, and backups, to name just a few. As is clear from the table of contents, this book is not simply a recitation of Oracle Database features such as what you find in the reference guides available for free download on the Oracle web site. For example, the chapter on database monitoring explains how to monitor database availability, database changes, database security, database backups, database growth, database workload, database performance, and database capacity. The chapters of this book are logically organized into four parts that closely track the way your database administration career will naturally evolve. Part 1 gives you necessary background in relational database theory and Oracle Database concepts, Part 2 teaches you how to implement an Oracle database correctly, Part 3 exposes you to the daily routine of a database administrator, and Part 4 introduces you to the fine art of performance tuning. Each chapter has exercises designed to help you apply the lessons of the chapter. Each chapter also includes a list of reference works that contain more information on the topic of the chapter. In this book, you'll find information that you won't find in other books on Oracle Database. Here you'll discover not only technical information, but also guidance on work practices that are as vital to your success as technical skills. The author's favorite chapter is "The Big Picture and the Ten Deliverables." If you take the lessons in that chapter to heart, you can quickly become a much better Oracle database administrator than you ever thought possible.

Oracle 11G

Oracle 11G
Author: Joan Casteel
Publisher: Course Technology
Total Pages: 608
Release: 2014-06-25
Genre: Computers
ISBN: 9781305268029
GET BOOK

Download Oracle 11G Book in PDF, Epub and Kindle

ORACLE 11G: SQL 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.

Oracle Database 10g: A Beginner's Guide

Oracle Database 10g: A Beginner's Guide
Author: Ian Abramson
Publisher: McGraw Hill Professional
Total Pages: 417
Release: 2004-04-21
Genre: Computers
ISBN: 0071706771
GET BOOK

Download Oracle Database 10g: A Beginner's Guide Book in PDF, Epub and Kindle

Provides beginning DBAs and developers with a solid foundation in the database administration and programming basics needed to embark on an Oracle career. The focus is on Oracle Database 10g, but you’ll get the fundamentals applicable to all Oracle database releases.

Oracle 11g For Dummies

Oracle 11g For Dummies
Author: Chris Zeis
Publisher: John Wiley & Sons
Total Pages: 410
Release: 2009-02-10
Genre: Computers
ISBN: 0470465077
GET BOOK

Download Oracle 11g For Dummies Book in PDF, Epub and Kindle

Are you a seasoned system administrator charged with setting up an Oracle database? Or did you suddenly become a DBA by default? If database administration with Oracle is part of your job, you’ll be glad to have Oracle 11g For Dummies in your cubicle. This nuts-and-bolts guide walks you through the mysteries of Oracle and database administration. You’ll learn how to understand Oracle database architecture, set up and manage an Oracle database, and keep it running in tiptop form. Oracle 11g For Dummies covers: The building blocks behind the database engine as well as Oracle’s physical and logical structures Hardware, software, system, and storage requirements for implementation How to recognize and accommodate the differences between Oracle installations on Windows and on Linux/UNIX Daily and intermittent tasks necessary to keep your database running properly How to assess potential threats to your database, configure Oracle Recovery Manager, and set up backup and recovery procedures When to use online, offline, controlfile, and archivelog backups Troubleshooting methodology and how to use Oracle database logs and other diagnostic utilities Different ways to manage your database How to automate jobs with the Oracle Scheduler Using SQL in Oracle, and a great deal more Completely up to date for the newest release of Oracle, Oracle 11g For Dummies will give you both the information and the confidence to set up and maintain an Oracle database for your organization.

Oracle 11g New Features

Oracle 11g New Features
Author: Brian Carr
Publisher: Rampant TechPress
Total Pages: 480
Release: 2008
Genre: Database management
ISBN: 0979795109
GET BOOK

Download Oracle 11g New Features Book in PDF, Epub and Kindle

Tackling some of the more than 500 updates to Oracle 11g that are intended to automate the inherent complexity of the Oracle engine, this guidebook explores all of the new features from the perspective of a working Oracle professional. This valuable resource examines only the important Oracle 11g enhancements and includes expert discussion about each new feature, why the new feature is important, and how to use the new 11g functionality. Written by working Oracle experts for both current DBAs and Oracle developers and programmers, this flagship book on Oracle 11g explores language and PL/SQL, DBA features, RAC and enhancements, performance features, new security features, and Enterprise Manager.

Oracle Database 11G - Underground Advice for Database Administrators

Oracle Database 11G - Underground Advice for Database Administrators
Author: April C. Sims
Publisher: Packt Publishing Ltd
Total Pages: 454
Release: 2010-04-08
Genre: Computers
ISBN: 1849680019
GET BOOK

Download Oracle Database 11G - Underground Advice for Database Administrators Book in PDF, Epub and Kindle

A real-world DBA survival guide for Oracle 11g database implementations with this book and eBook.

Oracle Database 10g DBA Handbook

Oracle Database 10g DBA Handbook
Author: Kevin Loney
Publisher: McGraw Hill Professional
Total Pages: 737
Release: 2005-04-14
Genre: Computers
ISBN: 0071770437
GET BOOK

Download Oracle Database 10g DBA Handbook Book in PDF, Epub and Kindle

Everything a DBA needs to know in one volume--this is the must-have reference for anyone working with the Oracle database, and it’s been fully revised and updated for Oracle Database 10g. Co-author Kevin Loney is the all-time, best-selling Oracle Press author.