Oracle Database 11g The Complete Reference
Step 1. Download Adobe Digital Editions Both PC and Mac users will need to download Adobe Digital Editions to access their eBook. You can download Adobe Digital Editions at Adobe's website here.
Step 2. Register an Adobe ID if you do not already have one. (This step is optional, but allows you to open the file on multiple devices) Visit account.Adobe.com to register your Adobe account.
Step 3: Authorize Adobe Digital Editions using your Adobe ID. In Adobe Digital Editions, go to the Help menu. Choose “Authorize Computer.”
Step 4: Open your file with Adobe Digital Editions. Once you’ve linked your Adobe Digital Editions with your Adobe ID, you should be able to access your eBook on any device which supports Adobe Digital Editions and is authorized with your ID. If your eBook does not open in Adobe Digital Editions upon download, please contact customer service
PART I: Critical Database Concepts
Ch 1: Oracle Database 10g Architecture Options
Ch 2: Installing Oracle Database 10g and Creating a Database
Ch 3: Upgrading to Oracle Database 10g
Ch 4: Planning Oracle Applications—Approaches, Risks, and Standards
PART II: SQL and SQL*Plus
Ch 5: The Basic Parts of Speech in SQL
Ch 6: Basic SQL*Plus Reports and Commands
Ch 7: Getting Text Information and Changing It
Ch 8: Searching for Regular Expressions
Ch 9: Playing the Numbers
Ch 10: Dates: Then, Now, and the Difference
Ch 11: Conversion and Transformation Functions
Ch 12: Grouping Things Together
Ch 13: When One Query Depends upon Another
Ch 14: Some Complex Possibilities
Ch 15: Changing Data insert, update, merge, and delete
Ch16: DECODE and CASE: if, then, and else in SQL
Ch 17: Creating and Managing Tables, Views, Indexes, Clusters, and Sequences
Ch 18: Editioning
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