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

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

**Topics**
+ [Single-row and aggregate functions](chap-oracle-aurora-pg.sql.aggregate.md)
+ [CREATE TABLE AS SELECT statement](chap-oracle-aurora-pg.sql.ctas.md)
+ [Common Table Expressions](chap-oracle-aurora-pg.sql.cte.md)
+ [Oracle identity columns and PostgreSQL SERIAL type](chap-oracle-aurora-pg.sql.identity.md)
+ [INSERT FROM SELECT statement](chap-oracle-aurora-pg.sql.ifs.md)
+ [Multi-Version Concurrency Control](chap-oracle-aurora-pg.sql.mvcc.md)
+ [MERGE statement](chap-oracle-aurora-pg.sql.merge.md)
+ [Oracle OLAP functions and PostgreSQL window functions](chap-oracle-aurora-pg.sql.olap.md)
+ [Oracle and PostgreSQL sequences](chap-oracle-aurora-pg.sql.sequences.md)
+ [Oracle transaction model and PostgreSQL transactions](chap-oracle-aurora-pg.sql.transactions.md)
+ [Oracle anonymous block and PostgreSQL DO](chap-oracle-aurora-pg.sql.block.md)
+ [Oracle and PostgreSQL cursors](chap-oracle-aurora-pg.sql.cursors.md)
+ [Oracle DBMS\_OUTPUT and PostgreSQL RAISE](chap-oracle-aurora-pg.sql.raise.md)
+ [Oracle DBMS\_RANDOM and PostgreSQL RANDOM function](chap-oracle-aurora-pg.sql.random.md)
+ [Oracle DBMS\_SQL package and PostgreSQL dynamic execution](chap-oracle-aurora-pg.sql.dynamic.md)
+ [Oracle EXECUTE IMMEDIATE and PostgreSQL EXECUTE and PREPARE](chap-oracle-aurora-pg.sql.immediate.md)
+ [Oracle procedures and functions and PostgreSQL stored procedures](chap-oracle-aurora-pg.sql.stored.md)
+ [Oracle and PostgreSQL user-defined functions](chap-oracle-aurora-pg.sql.udfs.md)
+ [Oracle UTL\_FILE package](chap-oracle-aurora-pg.sql.utl.md)
+ [Oracle UTL\_MAIL or UTL\_SMTP and PostgreSQL Scheduled Lambda with Amazon SES](chap-oracle-aurora-pg.sql.mail.md)