- Reference
- Nonfiction
- Bantam Loveswept
- Chipperfield, David
- Steinbeck, John
- Applique
- Vanuatu
- Christianity
- General
- Math & Science
- Logic
- Kushner, Tony
- Sex Instruction
- Books
- Pathophysiology
- General
- Poverty
- General
- Corelli
- General
- Series
- General
- Kellogg, Steven
- India
- Cobb, Ty
- Simmons, Dan
- Paperback
- Dexter, Susan
- Byers, Richard Lee
- Blood Type Diets
- Some of our other sites:
- Books
- Clothing, Shoes and Accessories
- Baby Clothes and Accessories
- Cosmetics, Beauty Products and Fragrances
- Cellphones, Call Plans and Accessories
- Video Games
- DVDs
- Electronics, Gadgets and Computers
- Health and Personal Care
- Home and Garden
- Home DIY
- Jewelry
- Magazines and Newspapers
- Music Downloads
- Musical Instruments
- Office Equipment and Supplies
- Software and Games
- Sporting Goods
- Toys and Games
- Watches
- UK Books
- UK Video Games
- UK Home and Garden
- UK Electronics, Gadgets and Computers
- UK Baby Clothes and Accessories
- UK Software and Games
- UK Sporting Goods
- UK Toys and Games
Books : Computers & Internet : Databases : Oracle
-
Application Express, or APEX, is one of the most innovative products to come out of Oracle in years. APEX is an application development framework for developing database–backed applications. It’s easy enough to get started in that power users can quit storing data in random spreadsheets and instead centralize their data in the powerful Oracle database, all without developer help. Developers arent left out, however. Those who choose to can go deep and leverage the full power and flexibility of Oracles database engine.
Getting started with APEX is easy. Learning how to take full advantage of APEX is the problem. It was the problem, that is, until this book came along. In Pro Oracle Application Express, authors John Scott and Scott Spendolini open the “hood” of APEX and expose the full power behind its easy–to–use GUI interface. They show you what you need to know to produce powerful, professionally polished applications, things such as user-authentication models, approaches to layout and navigation, how to integrate Ajax, how to deal with localization issues such as time zones and translations, how to customize the look and feel of an APEX web site, and much, much more.
The authors are well–qualified to write on APEX. John Scott runs ShellPrompt, a hosting service that handles many large-scale APEX applications, some of which he is paid to develop. John is a hard–core APEX developer. His coauthor, Scott Spendolini, is one of the original creators of APEX. Both John and Scott now base their fulltime careers on developing APEX applications. Pro Oracle APEX is your opportunity to learn APEX from the very best.
-
"Offers hundreds of hints, tips, and tricks of the trade that can be useful to any DBA wanting to achieve maximum performance of Oracle applications. No Oracle library would be complete without this book." --Ken (Dr. DBA) Jacobs, Vice President of Product Strategy for Server Technologies, Oracle Corporation
"Rich is the first and last stop for Oracle Database technology and performance tuning. His knowledge is a vital tool that you need to successfully negotiate the waters of Oracle database development." --Mike Frey, Principal Architect, Navteq
-
-
Complete exam prep from Oracle Press. This exclusive Oracle Press guide will prepare certification candidates for the newly reintroduced Oracle Certified Associate Oracle Database 11 g : SQL Fundamentals I exam. All exam topics are covered including installation, configuration, application tuning, database management, backup and recovery, security, and more. The CD-ROM contains two practice exams and an electronic copy of the book.
-
This book will help you make the best use of Oracle technology. Emulating Tom's rational methodology, and demand for proof-by-example, will make you a far better technology thinker. Without question, this is one of the most importantly Oracle books you can possess.
— Ken Jacobs, Vice President of Product Strategy (Server Technologies), Oracle Corporation
This is a defining book on the Oracle database for any developer or DBA who works with Oracle-driven database applications. Tom has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you will find that there are few information management problems that you cannot solve quickly and elegantly.
Expert Oracle Database Architecture is the first of a three-book series that completely explores and defines the Oracle database. It covers all of the most important Oracle architecture features, including:
- Files, memory structures and processes
- Locking and latching
- Transactions, concurrency and multi-versioning
- Tables and Indexes
- Datatypes
- Partitioning and parallelism
Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it.
This fully revised edition covers both the 9i and 10g versions. It also comes with a CD containing a searchable PDF of the 8i version of the book.
Tom has fully revised and expanded the architecture-related sections from Expert One-on-One Oracle (a searchable PDF of which is included on the CD accompanying this book), and added substantial new material. He focuses solely on 9i and 10g architecture in this book and refers to the CD for 8i-specific details. The number of changes will surprise you.
In summary, this book provides a one-stop resource containing deep wisdom on the design, development and administration of Oracle applications, written by one of the world's foremost Oracle experts, Thomas Kyte.
-
Designed for an introductory course in database management which is usually required as part of an information systems curriculum in business school, computer technology programs, and applied computer science departments.
-
-
Four for the price of one! Oracle Database 10g OCP Certification All-in-One Exam Guide is the only book that offers thorough exam prep and a great on-the-job reference for both the latest OCA and OCP exams.Also includes the Boson’s Oracle self-assessment engine to get experience taking the test in the environment it will be given
-
-
The Most Complete Guide to Maximizing Oracle Recovery Manager
Deploy a rock-solid data backup and disaster recovery strategy with the in-depth guidance of this authoritative volume. From the exclusive publishers of Oracle Press books, Oracle Database 10g RMAN Backup & Recovery shows you, step by step, how to set up RMAN-ready databases, create reliable backup tapes and discs, and perform accurate Oracle system restores. Find out how to use RMAN from the command line and from Enterprise Manager, generate meaningful lists and reports, and automate administrative tasks using third-party media management tools. Plus, you'll learn to perform incremental backups, Flashback recoveries, and database cloning.
- Set up, configure, and maintain Oracle Database 10g RMAN
- Use RMAN recovery catalogs, target database packages, and control files
- Centralize backup tape management using Oracle Secure Backup
- Perform online, offline, and incremental system backups
- Monitor and tune performance with Enterprise Manager Grid Control and Database Control
- Accomplish complete and partial RMAN database restores
- Improve functionality using VERITAS NetBackup, EMC NetWorker Module, and Tivoli Storage Manager
- Overcome human errors using Flashback Versions Query and Transaction Query
- Create clone and standby databases from tape and disc backups
- Work with Real Application Cluster (RAC) databases and sync-and-split hardware technologies
-
A Fully Integrated Study System for OCA Exam 1Z0-052
Prepare for the Oracle Certified Associate Oracle Database 11g Administration I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-052, including:
- Database architecture
- Creating an Oracle Database
- Managing the Oracle instance
- Configuring and managing the Oracle network
- Managing database storage structures
- Administering user security
- Managing schema objects, data and concurrency, and undo data
- Implementing Oracle Database security
- Database maintenance and performance management
- Backup and recovery
- Moving data
- Intelligent infrastructure enhancements
On the CD-ROM:
- One full practice exam that simulates the actual OCA exam
- Detailed answers and explanations
- Score report performance assessment tool
- Complete electronic book
- Bonus exam available free with online registration
-
Oracle is an enormous system, with myriad technologies, options, and releases. Most users-even experienced developers and database administrators-find it difficult to get a handle on the full scope of the Oracle database. And, as each new Oracle version is released, users find themselves under increasing pressure to learn about a whole range of new technologies. The latest challenge is Oracle Database 11g. This book distills an enormous amount of information about Oracle into a compact, easy-to-read volume filled with focused text, illustrations, and helpful hints. It contains chapters on: Oracle products, options, data structures, and overall architecture for Oracle Database 11g, as well as earlier releases (Oracle Database 10g, Oracle9i, and Oracle8i) Installing, running, managing, monitoring, networking, and tuning Oracle, including Enterprise Manager (EM) and Oracle's self-tuning and management capabilities; and using Oracle security, auditing, and compliance (a new chapter in this edition) Multiuser concurrency, data warehouses, distributed databases, online transaction processing (OLTP), high availability, and hardware architectures (e.g., SMP, clusters, NUMA, and grid computing) Features beyond the Oracle database: Oracle Application Express, Fusion Middleware (including Oracle Application Server), and database SOA support as a Web services provider The latest Oracle Database 11g features: query result set caching, Automatic Memory Management, the Real Application Testing, Advanced Compression, Total Recall, and Active Data Guard Option Options, changes to the OLAP Option (transparently accessed and managed as materialized views), the Flashback transaction command, transparentdata encryption, the Support Workbench (and diagnosability infrastructure), and partitioning enhancements (including interval and new composite types) For new Oracle users, DBAs, developers, and managers, Oracle Essentials provides an invaluable, all-in-one introduction to the full range of Oracle features and technologies, including the just-released Oracle Database 11g features. But even if you already have a library full of Oracle documentation, you'll find that this compact book is the one you turn to, again and again, as your one-stop, truly essential reference. "Oracle Essentials gives a clear explanation of the key database concepts and architecture underlying the Oracle database. It's a great reference for anyone doing development or management of Oracle databases." --Andrew Mendelsohn, Senior Vice President, Database Server Technologies, Oracle Corporation
-
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.
-
Learn cutting-edge technology from Oracle expertsWritten by Oracle insiders, this comprehensive guide covers everything you need to know about Real Application Clusters -- low-cost hardware platforms that can rival and exceed the quality of service, availability, and scalability of the most expensive mainframe systems.
- Concepts covered are applicable to all previous versions of Oracle
- Tuning and troubleshooting tips, providing insight on the most advanced diagnostics available
- Detailed coverage of advanced RAC concepts
- Working code for all examples available online
-
Create dynamic client/server applications using PL/SQL and the comprehensive information contained in this authoritative volume. Expert Oracle insiders cover the features of PL/SQL, explain scripting semantics and syntax, and fully detail the PL/SQL functionality of Oracle Database 10g. You-ll learn how to write powerful PL/SQL programs, interact with Oracle databases, perform complex calculations, and handle error conditions.
-
Build and manage a scalable storage infrastructure with Oracle Automatic Storage Management
Streamline data management and provisioning using Oracle Automatic Storage Management (Oracle ASM) and the detailed information contained in this exclusive Oracle Press resource. Written by a team of database experts, Oracle Automatic Storage Management: Under-the-Hood & Practical Deployment Guide explains how to build and maintain a dynamic, highly available Oracle database storage environment. Inside, you'll learn how to configure storage for Oracle ASM, build disk groups, use data striping and mirroring, and optimize performance. You'll also learn how to ensure consistency across server and storage platforms, maximize data redundancy, and administer Oracle ASM from the command line.- Manage Oracle ASM Instances and configure Oracle RDBMS instances to leverage Oracle ASM
- Define, discover, and manage disk storage under Oracle ASM
- Create external, normal-redundancy, and high-redundancy disk groups
- Add and remove Oracle ASM storage without affecting RDMS instance availability
- Learn how Oracle ASM provides even I/O distribution
- Work with Oracle ASM directories, files, templates, and aliases
- Improve storage performance and integrity using the ASMLIB API
- Simplify system administration with the Oracle ASM command line interface
- Understand key internal Oracle ASM structures and algorithms
-
-
The Essential Resource for Oracle DBAs--Fully Updated and ExpandedManage a flexible, highly available Oracle database with help from the expert information contained in this exclusive Oracle Press guide. Fully revised to cover every new feature and utility, Oracle Database 11g DBA Handbook shows how to perform a new installation, upgrade from previous versions, configure hardware and software for maximum efficiency, and employ bulletproof security. You will learn to automate the backup and recovery process, provide transparent failover capability, audit and tune performance, and distribute your enterprise databases with Oracle Net.
- Plan and deploy permanent, temporary, and bigfile tablespaces
- Optimize disk allocation, CPU usage, I/O throughput, and SQL queries
- Develop powerful database management applications
- Guard against human errors using Oracle Flashback and Oracle Automatic Undo Management
- Diagnose and tune system performance using Oracle Automatic Workload Repository and SQL Tuning Sets
- Implement robust security using authentication, authorization, fine-grained auditing, and fine-grained access control
- Maintain high availability using Oracle Real Application Clusters and Oracle Active Data Guard
- Respond more efficiently to failure scenarios by leveraging the Oracle Automatic Diagnostic Repository and the Oracle Repair Advisor
- Back up and restore tables, tablespaces, and databases with Oracle Recovery Manager and Oracle Data Pump Export and Import
- Work with networked databases, data warehouses, and VLDBs
- Put the latest Oracle Database 11g tools to work--Oracle Total Recall, Oracle Flashback Data Archive, and more
-
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
Benjamin Rosenzweig is a Software Development Manager at Misys. Previously he was a Principal Consultant at Oracle. His experience ranges from creating an electronic Tibetan—English Dictionary in Kathmandu, Nepal, to supporting presentation centers at Goldman Sachs and managing trading systems at TIAA-CREF. As an instructor at Columbia University’s Computer Technology and Application Program, he was awarded the Outstanding Teaching Award. Rosenzweig wrote and presented Oracle Forms Developer: The Complete Video Course, and coauthored Oracle Web Application Programming for PL/SQL Developers.
Elena Silvestrova Rakhimov is Senior Developer and Team Lead at Alea Software. She has more than fifteen years of experience in database development in a wide spectrum of enterprise and business environments, ranging from non-profit organizations to Wall Street. She has taught database programming at Columbia University.
Contents
Acknowledgments xiv
About the Authors xv
Introduction xvii
CHAPTER 1 PL/SQL Concepts 1
LAB 1.1 PL/SQL in Client/Server Architecture 2
1.1.1 Use PL/SQL Anonymous Blocks 8
1.1.2 Understand How PL/SQL Gets Executed 10
LAB 1.2 PL/SQL in SQL*Plus 12
1.2.1 Use Substitution Variables 16
1.2.2 Use the DBMS_OUTPUT.PUT_LINE Statement 17
Chapter 1 Try It Yourself 19
CHAPTER 2 General Programming Language
Fundamentals 21
LAB 2.1 PL/SQL Programming Fundamentals 22
2.1.1 Make Use of PL/SQL Language Components 23
2.1.2 Make Use of PL/SQL Variables 24
2.1.3 Handle PL/SQL Reserved Words 26
2.1.4 Make Use of Identifiers in PL/SQL 27
2.1.5 Make Use of Anchored Datatypes 28
2.1.6 Declare and Initialize Variables 31
2.1.7 Understand the Scope of a Block, Nested Blocks, and Labels 34
Chapter 2 Try It Yourself 37
CHAPTER 3 SQL in PL/SQL 39
LAB 3.1 Making Use of DML in PL/SQL 40
3.1.1 Use the Select INTO Syntax for Variable Initialization 41
3.1.2 Use DML in a PL/SQL Block 42
3.1.3 Make Use of a Sequence in a PL/SQL Block 44
LAB 3.2 Making Use of SAVEPOINT 45
3.2.1 Make Use of COMMIT, ROLLBACK, and SAVEPOINT in a PL/SQL Block 48
Chapter 3 Try It Yourself 51
CHAPTER 4 Conditional Control: IF Statements 53
LAB 4.1 IF Statements 54
4.1.1 Use the IF-THEN Statement 58
4.1.2 Use the IF-THEN-ELSE Statement 62
LAB 4.2 ELSIF Statements 65
4.2.1 Use the ELSIF Statement 69
LAB 4.3 Nested IF Statements 74
4.3.1 Use Nested IF Statements 76
Chapter 4 Try It Yourself 80
CHAPTER 5 Conditional Control: CASE Statements 81
LAB 5.1 CASE Statements 82
5.1.1 Use the CASE Statement 89
5.1.2 Use the Searched CASE Statement 91
LAB 5.2 CASE Expressions 96
5.2.1 Use the CASE Expression 100
LAB 5.3 NULLIF and COALESCE Functions 103
5.3.1 The NULLIF Function 107
5.3.2 Use the COALESCE Function 109
Chapter 5 Try It Yourself 112
CHAPTER 6 Iterative Control: Part I 113
LAB 6.1 Simple Loops 114
6.1.1 Use Simple Loops with EXIT Conditions 118
6.1.2 Use Simple Loops with EXIT WHEN Conditions 120
LAB 6.2 WHILE Loops 124
6.2.1 Use WHILE Loops 128
LAB 6.3 Numeric FOR Loops 132
6.3.1 Use Numeric FOR Loops with the IN Option 137
6.3.2 Use Numeric FOR Loops with the REVERSE Option 139
Chapter 6 Try It Yourself 142
CHAPTER 7 Iterative Control: Part II 143
LAB 7.1 The CONTINUE Statement 144
7.1.1 Use t...
-
Oracle Applications DBA covers all the pertinent aspects of administrating Oracle Applications—from installation to day-to-day maintenance. It covers upgrading, cloning, patching, maintenance and troubleshooting of the application system. Embellished with over 350 screenshots and illustrations, it helps in administrating complex Oracle Database in an easy-to-navigate format. To help readers manage Oracle Applications without much difficulty, a comprehensive discussion on upgrading Oracle Applications in Unix environment has been provided. Further the book includes a balanced coverage of Oracle 11i and R12 – making it a must-have for experienced Oracle Applications DBAs. Professionals who are keen to migrate from DBA to Apps DBA profile would also find the book useful.