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