SQL and PL/SQL

This section provides reference pages to Oracle and MySQL functions, statements, and other commands.

Topics

• Single-row and aggregate Oracle and MySQL functions
• Oracle and MySQL CREATE TABLE AS SELECT statement
• Oracle and MySQL Common Table Expressions
• Oracle sequences and identity columns and MySQL sequences and AUTO INCREMENT columns
• Oracle and MySQL INSERT FROM SELECT statement
• Multi-Version Concurrency Control
• Oracle MERGE statement and MySQL equivalent
• Oracle OLAP functions and MySQL Window functions
• Oracle Transaction Model and MySQL Transactions
• Oracle anonymous block and MySQL transactions or procedures
• Conversion functions
• Oracle and MySQL cursors
• Oracle DBMS_DATAPUMP and MySQL integration with Amazon S3
• Oracle DBMS_OUTPUT and MySQL SELECT
• Oracle DBMS_RANDOM and MySQL RAND function
• Oracle DBMS_REDEFINITION and MySQL tables and triggers
• Oracle DBMS_SQL
• Oracle EXECUTE IMMEDIATE and MySQL EXECUTE and PREPARE statements
• Oracle procedures and functions and MySQL stored procedures
• Oracle and MySQL regular expressions
• Oracle TIMEZONE data type and functions and MySQL CONVERT_TZ function
• Oracle and MySQL user-defined functions
• Oracle UTL_FILE and MySQL integration with Amazon S3
• Oracle UTL_MAIL or UTL_SMTP and Amazon Simple Notification Service