SQL and PL/SQL

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

Topics

• Single-row and aggregate functions
• CREATE TABLE AS SELECT statement
• Common Table Expressions
• Oracle identity columns and PostgreSQL SERIAL type
• INSERT FROM SELECT statement
• Multi-Version Concurrency Control
• MERGE statement
• Oracle OLAP functions and PostgreSQL window functions
• Oracle and PostgreSQL sequences
• Oracle transaction model and PostgreSQL transactions
• Oracle anonymous block and PostgreSQL DO
• Oracle and PostgreSQL cursors
• Oracle DBMS_OUTPUT and PostgreSQL RAISE
• Oracle DBMS_RANDOM and PostgreSQL RANDOM function
• Oracle DBMS_SQL package and PostgreSQL dynamic execution
• Oracle EXECUTE IMMEDIATE and PostgreSQL EXECUTE and PREPARE
• Oracle procedures and functions and PostgreSQL stored procedures
• Oracle and PostgreSQL user-defined functions
• Oracle UTL_FILE package
• Oracle UTL_MAIL or UTL_SMTP and PostgreSQL Scheduled Lambda with Amazon SES