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 Lamda with SES