Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Acknowledgments
Introduction
PART I Development Components
Client Software: SQL*Plus
Oracle 11 g Server Software
Oracle Data Dictionary
Client Software: The MySQL Monitor
MySQL Server Software
MySQL Data Dictionary
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
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
Securing the Network
Securing the Operating System
Securing the Database
Data Control Language
Definer Rights
Invoker Rights
INSERT Statement
UPDATE Statement
DELETE Statement
Oracle NOT NULL Constraints
MySQL NOT NULL Constraints
Oracle UNIQUE Constraints
MySQL UNIQUE Constraints
Unique Indexes
Oracle Primary Key Constraints
MySQL Primary Key Constraints
Oracle Foreign Key Constraints
MySQL Foreign Key Constraints
Oracle CHECK Constraints
MySQL CHECK Constraints
1 Architecture
General Client-Server Computing Model
Oracle Database 11 g
Oracle MySQL 5.6
Summary
Mastery Check
2 Client Interface
SQL*Plus
MySQL Monitor
Summary
Mastery Check
3 Security Models
Security Barriers
Security Privileges
Definer and Invoker Rights
Summary
Mastery Check
4 Transaction Models
Data Transactions
ACID-compliant SQL Statements
Stored Programs
Triggers
Summary
Mastery Check
5 Constraints
NOT NULL Constraints
UNIQUE Constraints
Primary Key Constraints
Foreign Key Constraints
CHECK Constraints
Trigger Constraints
Summary
Mastery Check
PART II SQL Development
Oracle Users
MySQL Users
Oracle Schemas
MySQL Databases
Oracle Tables
MySQL Tables
Oracle Indexes
MySQL Indexes
Oracle Users
MySQL Users
Enable SQL Tracing
Enable Conditional Compilation
Data Catalog Table Definitions
Adding, Modifying, and Dropping Columns
Dropping Tables
Oracle Index Maintenance
MySQL Index Maintenance
Oracle Drop Views
MySQL Drop Views
Oracle Insert by Values
MySQL Insert by Values
Oracle Insert by Queries
MySQL Insert by Queries
Oracle Update by Values and Queries
MySQL Update by Values
Oracle Correlated Queries
MySQL Correlated Queries
Delete Nested Table Row Elements
MySQL Delete by Multiple-Table Statement
Queries that Return Columns or Results from Columns
Queries that Aggregate
Queries that Return Columns or Results Selectively
Joins that Splice Together Rows
Joins that Splice Collections
Creating Oracle Views
Creating MySQL Views
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
Import and Export Data Processes
Merging with the INSERT statement
Merging with the REPLACE INTO Statement
Anonymous Blocks
Named Blocks
Text Data Types
Date Types
Number Types
Composite Variable Types
If Statement
CASE Statement
Iterative Structures
NDS Statements Without Bind Variables
NDS Statements with Bind Variables
User-Defined Exceptions
Dynamic User-Defined Exceptions
Function and Procedure Coding Rules
SQL/PSM Functions
SQL/PSM Procedures
SQL/PSM Local Variables
SQL/PSM Cursors
SQL/PSM Handlers
If Statements
CASE Statements
Loop Statements
Prepared Statements at the Command Line
Prepared Statements in Stored Programs
Oracle Trigger Architecture
MySQL Trigger Architecture
Oracle DDL Triggers
MySQL DDL Triggers
Oracle DML Triggers
MySQL DML Triggers
Oracle Compound Triggers
MySQL Compound Triggers
Oracle INSTEAD OF Triggers
MySQL Instead-of Triggers
Oracle System Triggers
MySQL System Triggers
Mastery Check Answers
Index
6 Creating Users and Structures
Users
Databases
Tables
Indexes
Summary
Mastery Check
7 Modifying Users and Structures
Users
Database
Sessions
Tables
Indexes
Views
Summary
Mastery Check
8 Inserting Data
Insert by Values
Insert by Queries
Summary
Mastery Check
9 Updating Data
Update by Values and Queries
Update by Correlated Queries
Summary
Mastery Check
10 Deleting Data
Delete by Value Matches
Delete by Correlated Queries
Summary
Mastery Check
11 Querying
Query Results
Join Results
Views: Stored Queries
Summary
Mastery Check
12 Merging Data
Merging Data in Oracle
Merging Data in MySQL
Summary
Mastery Check
13 PL/SQL Programming Language
PL/SQL Blocks
PL/SQL Variables: Types, Assignments, and Operators
PL/SQL Control Structures
Bulk Operations
Native Dynamic SQL
Exception Handling
Summary
Mastery Check
14 SQL/PSM Basics
SQL/PSM Stored Programs
SQL/PSM Variables
SQL/PSM Control Structures
Prepared Statements
Summary
Mastery Check
15 Triggers
Trigger Architecture
DDL Triggers
DML Triggers
Compound Triggers
INSTEAD OF Triggers
System Triggers
Summary
Mastery Check
← Prev
Back
Next →
← Prev
Back
Next →