Sign in  |  Register
Advanced search
Publication Cover

CITATION

McLaughlin, Michael. Oracle Database 11g & MySQL 5.6 Developer Handbook. US: McGraw-Hill Osborne Media, 2011.

Oracle Database 11g & MySQL 5.6 Developer Handbook

Authors: Michael McLaughlin

Published:  September 2011

eISBN: 9780071768863 0071768866 | ISBN: 9780071768856
Open eBook
  • Cover
  • Contents at a Glance
  • Contents
  • Acknowledgments
  • Introduction
  • Part I: Development Components
  • 1 Architecture
  • General Client-Server Computing Model
  • Oracle Database 11g
  • Client Software: SQL*Plus
  • Oracle 11g Server Software
  • Oracle Data Dictionary
  • Oracle MySQL 5.6
  • Client Software: The MySQL Monitor
  • MySQL Server Software
  • MySQL Data Dictionary
  • Summary
  • Mastery Check
  • 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
  • Security Barriers
  • Securing the Network
  • Securing the Operating System
  • Securing the Database
  • Security Privileges
  • Data Control Language
  • Definer and Invoker Rights
  • Definer Rights
  • Invoker Rights
  • Summary
  • Mastery Check
  • 4 Transaction Models
  • Data Transactions
  • ACID-compliant SQL Statements
  • INSERT Statement
  • UPDATE Statement
  • DELETE Statement
  • Stored Programs
  • Triggers
  • Summary
  • Mastery Check
  • 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
  • Users
  • Oracle Users
  • MySQL Users
  • Databases
  • Oracle Schemas
  • MySQL Databases
  • Tables
  • Oracle Tables
  • MySQL Tables
  • Indexes
  • Oracle Indexes
  • MySQL Indexes
  • Summary
  • Mastery Check
  • 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
  • Insert by Values
  • Oracle Insert by Values
  • MySQL Insert by Values
  • Insert by Queries
  • Oracle Insert by Queries
  • MySQL Insert by Queries
  • Summary
  • Mastery Check
  • 9 Updating Data
  • Update by Values and Queries
  • Oracle Update by Values and Queries
  • MySQL Update by Values
  • Update by Correlated Queries
  • Oracle Correlated Queries
  • MySQL Correlated Queries
  • Summary
  • Mastery Check
  • 10 Deleting Data
  • Delete by Value Matches
  • Delete Nested Table Row Elements
  • Delete by Correlated Queries
  • MySQL Delete by Multiple-Table Statement
  • Summary
  • Mastery Check
  • 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