Book description
Master Application Development in a Mixed-Platform Environment
Build powerful database applications in a mixed environment using the detailed information in this Oracle Press guide. Oracle Database 11g & MySQL 5.6 Developer Handbook lays out programming strategies and best practices for seamlessly operating between the two platforms. Find out how to migrate databases, port SQL dialects, work with Oracle MySQL databases, and configure effective queries. Security, monitoring, and tuning techniques are also covered in this comprehensive volume.
- Understand Oracle Database 11g and MySQL 5.6 architecture
- Convert databases between platforms and ensure transactional integrity
- Create tables, sequences, indexes, views, and user accounts
- Build and debug PL/SQL, SQL*Plus, SQL/PSM, and MySQL Monitor scripts
- Execute complex queries and handle numeric and date mathematics
- Merge data from source tables and set up virtual directories
Table of contents
- Cover
- Contents at a Glance
- Contents
- Acknowledgments
- Introduction
-
PART I Development Components
- 1 Architecture
-
2 Client Interface
- SQL*Plus
- Connecting to and Disconnecting from SQL*Plus
- Working in the SQL*Plus Environment
- Writing SQL Statements with SQL*Plus
- Saving SQL Statements with SQL*Plus
- Editing SQL Statements with SQL*Plus
- Rerunning SQL*Plus SQL Statements from the Buffer
- Aborting Entry of SQL Statements in SQL*Plus
- Calling and Running SQL*Plus Script Files
- Passing Parameters to SQL*Plus Script Files
- Calling PL/SQL Programs
- Writing SQL*Plus Log Files
- MySQL Monitor
- Connecting to and Disconnecting from MySQL Monitor
- Writing MySQL SQL Statements
- Saving MySQL SQL Statements
- Editing MySQL SQL Statements
- Aborting MySQL SQL Statements
- Calling and Running MySQL Script Files
- Setting a Session Variable
- Calling SQL/PSM Programs
- Writing MySQL Log Files
- Summary
- Mastery Check
- 3 Security Models
- 4 Transaction Models
-
5 Constraints
- NOT NULL Constraints
- Oracle NOT NULL Constraints
- MySQL NOT NULL Constraints
- UNIQUE Constraints
- Oracle UNIQUE Constraints
- MySQL UNIQUE Constraints
- Unique Indexes
- Primary Key Constraints
- Oracle Primary Key Constraints
- MySQL Primary Key Constraints
- Foreign Key Constraints
- Oracle Foreign Key Constraints
- MySQL Foreign Key Constraints
- CHECK Constraints
- Oracle CHECK Constraints
- MySQL CHECK Constraints
- Trigger Constraints
- Summary
- Mastery Check
-
PART II SQL Development
- 6 Creating Users and Structures
-
7 Modifying Users and Structures
- Users
- Oracle Users
- MySQL Users
- Database
- Sessions
- Enable SQL Tracing
- Enable Conditional Compilation
- Tables
- Data Catalog Table Definitions
- Adding, Modifying, and Dropping Columns
- Dropping Tables
- Indexes
- Oracle Index Maintenance
- MySQL Index Maintenance
- Views
- Oracle Drop Views
- MySQL Drop Views
- Summary
- Mastery Check
- 8 Inserting Data
- 9 Updating Data
- 10 Deleting Data
-
11 Querying
- Query Results
- Queries that Return Columns or Results from Columns
- Queries that Aggregate
- Queries that Return Columns or Results Selectively
- Join Results
- Joins that Splice Together Rows
- Joins that Splice Collections
- Views: Stored Queries
- Creating Oracle Views
- Creating MySQL Views
- Summary
- Mastery Check
-
12 Merging Data
- Merging Data in Oracle
- Step 1: Create a Virtual Directory
- Step 2: Position Your Physical CSV File
- Step 3: Create Example Tables
- Step 4: Test Configuration
- Step 5: Merge the Import Source
- Merging Data in MySQL
- Import and Export Data Processes
- Merging with the INSERT statement
- Merging with the REPLACE INTO Statement
- Summary
- Mastery Check
-
13 PL/SQL Programming Language
- PL/SQL Blocks
- Anonymous Blocks
- Named Blocks
- PL/SQL Variables: Types, Assignments, and Operators
- Text Data Types
- Date Types
- Number Types
- Composite Variable Types
- PL/SQL Control Structures
- If Statement
- CASE Statement
- Iterative Structures
- Bulk Operations
- Native Dynamic SQL
- NDS Statements Without Bind Variables
- NDS Statements with Bind Variables
- Exception Handling
- User-Defined Exceptions
- Dynamic User-Defined Exceptions
- Summary
- Mastery Check
-
14 SQL/PSM Basics
- SQL/PSM Stored Programs
- Function and Procedure Coding Rules
- SQL/PSM Functions
- SQL/PSM Procedures
- SQL/PSM Variables
- SQL/PSM Local Variables
- SQL/PSM Cursors
- SQL/PSM Handlers
- SQL/PSM Control Structures
- If Statements
- CASE Statements
- Loop Statements
- Prepared Statements
- Prepared Statements at the Command Line
- Prepared Statements in Stored Programs
- Summary
- Mastery Check
-
15 Triggers
- Trigger Architecture
- Oracle Trigger Architecture
- MySQL Trigger Architecture
- DDL Triggers
- Oracle DDL Triggers
- MySQL DDL Triggers
- DML Triggers
- Oracle DML Triggers
- MySQL DML Triggers
- Compound Triggers
- Oracle Compound Triggers
- MySQL Compound Triggers
- INSTEAD OF Triggers
- Oracle INSTEAD OF Triggers
- MySQL Instead-of Triggers
- System Triggers
- Oracle System Triggers
- MySQL System Triggers
- Summary
- Mastery Check
- Mastery Check Answers
- Index
Product information
- Title: Oracle Database 11g & MySQL 5.6 Developer Handbook
- Author(s):
- Release date: October 2011
- Publisher(s): Oracle Press
- ISBN: 9780071768863
You might also like
book
Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach
Performance problems are rarely "problems" per se. They are more often "crises" during which you're pressured …
book
Oracle SQL Revealed: Executing Business Logic in the Database Engine
Write queries using little-known, but powerful, SQL features implemented in Oracle's database engine. You will be …
book
Oracle Database 11g PL/SQL Programming
Design Feature-Rich PL/SQL Applications Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming …
book
Oracle RMAN for Absolute Beginners
Oracle RMAN for Absolute Beginners is a gentle introduction to the use of Oracle's Recovery Manager …