Contents

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions
• Third-Party License Information

1 Introduction

2 Oracle and MySQL Compared

• 2.1 Database Security
  • 2.1.1 Database Authentication
  • 2.1.2 Privileges
• 2.2 Schema Migration
  • 2.2.1 Schema Object Similarities
  • 2.2.2 Schema Object Names
  • 2.2.3 Table Design Considerations
    • 2.2.3.1 Character Data Types
    • 2.2.3.2 Column Default Value
  • 2.2.4 Migrating Multiple Databases
  • 2.2.5 Schema Migration Considerations for MySQL
    • 2.2.5.1 Databases
    • 2.2.5.2 Mapping MySQL Global and Database-Level Privileges to Oracle System Privileges
    • 2.2.5.3 Temporary Tables
    • 2.2.5.4 Owner of Schema Objects
• 2.3 Data Types
  • 2.3.1 Supported Oracle Data Types
  • 2.3.2 Default Data Type Mappings
  • 2.3.3 Comparing Data Types
    • 2.3.3.1 Numeric Types
    • 2.3.3.2 Date and Time Types
    • 2.3.3.3 String Types
• 2.4 Data Storage Concepts

3 Triggers and Stored Procedures

• 3.1 Triggers
• 3.2 Stored Procedures
  • 3.2.1 Individual SQL Statements
    • 3.2.1.1 REPLACE Statement
    • 3.2.1.2 DO Statement
    • 3.2.1.3 Compound DECLARE Statement
    • 3.2.1.4 Compound SET Statement
  • 3.2.2 Variables in Stored Procedures
  • 3.2.3 Error Handling in Stored Procedures

4 Troubleshooting

• 4.1 Defining the User Account
• 4.2 Dumping MySQL Data
• 4.3 Optimizing Command Line Options

Index