# SQL and PL/SQL
<a name="chap-oracle-aurora-mysql.sql"></a>

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

**Topics**
+ [Single-row and aggregate Oracle and MySQL functions](chap-oracle-aurora-mysql.sql.aggregate.md)
+ [Oracle and MySQL CREATE TABLE AS SELECT statement](chap-oracle-aurora-mysql.sql.ctas.md)
+ [Oracle and MySQL Common Table Expressions](chap-oracle-aurora-mysql.sql.cte.md)
+ [Oracle sequences and identity columns and MySQL sequences and AUTO INCREMENT columns](chap-oracle-aurora-mysql.sql.identity.md)
+ [Oracle and MySQL INSERT FROM SELECT statement](chap-oracle-aurora-mysql.sql.ifs.md)
+ [Multi-Version Concurrency Control](chap-oracle-aurora-mysql.sql.mvcc.md)
+ [Oracle MERGE statement and MySQL equivalent](chap-oracle-aurora-mysql.sql.merge.md)
+ [Oracle OLAP functions and MySQL Window functions](chap-oracle-aurora-mysql.sql.olap.md)
+ [Oracle Transaction Model and MySQL Transactions](chap-oracle-aurora-mysql.sql.transactions.md)
+ [Oracle anonymous block and MySQL transactions or procedures](chap-oracle-aurora-mysql.sql.block.md)
+ [Conversion functions](chap-oracle-aurora-mysql.sql.conversionfunctions.md)
+ [Oracle and MySQL cursors](chap-oracle-aurora-mysql.sql.cursors.md)
+ [Oracle DBMS\$1DATAPUMP and MySQL integration with Amazon S3](chap-oracle-aurora-mysql.sql.datapump.md)
+ [Oracle DBMS\$1OUTPUT and MySQL SELECT](chap-oracle-aurora-mysql.sql.raise.md)
+ [Oracle DBMS\$1RANDOM and MySQL RAND function](chap-oracle-aurora-mysql.sql.random.md)
+ [Oracle DBMS\$1REDEFINITION and MySQL tables and triggers](chap-oracle-aurora-mysql.sql.redefinition.md)
+ [Oracle DBMS\$1SQL](chap-oracle-aurora-mysql.sql.dynamic.md)
+ [Oracle EXECUTE IMMEDIATE and MySQL EXECUTE and PREPARE statements](chap-oracle-aurora-mysql.sql.immediate.md)
+ [Oracle procedures and functions and MySQL stored procedures](chap-oracle-aurora-mysql.sql.stored.md)
+ [Oracle and MySQL regular expressions](chap-oracle-aurora-mysql.sql.regularexpressions.md)
+ [Oracle TIMEZONE data type and functions and MySQL CONVERT\$1TZ function](chap-oracle-aurora-mysql.sql.timezone.md)
+ [Oracle and MySQL user-defined functions](chap-oracle-aurora-mysql.sql.udfs.md)
+ [Oracle UTL\$1FILE and MySQL integration with Amazon S3](chap-oracle-aurora-mysql.sql.utl.md)
+ [Oracle UTL\$1MAIL or UTL\$1SMTP and Amazon Simple Notification Service](chap-oracle-aurora-mysql.sql.mail.md)