SQL and PL/SQL
Topics
- Single-Row and Aggregate Functions
- Create Table as Select
- Common Table Expressions
- Oracle Identity Columns and PostgreSQL SERIAL Type
- Insert From Select
- Multi-Version Concurrency Control
- Merge
- Oracle OLAP Functions and PostgreSQL Window Functions
- Sequences
- Oracle Transaction Model and PostgreSQL Transactions
- Oracle Anonymous Block and PostgreSQL DO
- 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
- User-Defined Functions
- Oracle UTL_FILE
- Oracle UTL_MAIL or UTL_SMTP and PostgreSQL Scheduled Lamda with SES