SQL and PL/SQL
Topics
- Single-Row and Aggregate Functions
- Create Table as Select
- Common Table Expressions
- Oracle Sequences and Identity Columns and MySQL Sequences and AUTO INCREMENT Columns
- Insert From Select
- Multi-Version Concurrency Control
- Merge
- Oracle OLAP Functions and MySQL Window Functions
- Oracle Transaction Model and MySQL Transactions
- Oracle Anonymous Block and MySQL Transactions or Procedures
- Conversion Functions
- 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
- DBMS_SQL
- Oracle EXECUTE IMMEDIATE and MySQL EXECUTE and PREPARE
- Oracle Procedures and Functions and MySQL Stored Procedures
- Regular Expressions
- Oracle TIMEZONE Data Type and Functions and MySQL CONVERT_TZ Function
- User-Defined Functions
- Oracle UTL_FILE and MySQL Integration with Amazon S3
- Oracle UTL_MAIL or UTL_SMTP and Amazon Simple Notification Service