SQLANDPLSQL.COM

PostgreSQL	Oracle/PLSQL
To_char (numeric)	SELECT statement
To_char (date/time)	To_char
Data Types	To_date
CREATE table	Row_number
CREATE sequence	Julian date
String functions	PLJSON – JSON extension for PL/SQL
Mathematical functions	Joins
Formatting functions	5 ways to delete duplicate records Oracle
Date/Time functions	Difference between TRUNCATE and DELETE
XML functions	Difference between TRUNC and ROUND
JSON functions	Difference between UNION and UNION ALL clause
BYTEA/BLOB functions	Difference between DECODE and CASE
Array functions	Find nth highest salary
Range functions	DUAL table
Aggregate Functions	5 different ways to test Ref Cursor results
Window Functions	5 different ways to load flat file
Conditional Expression	5 different ways to delete duplicate records
CASE Expression	CASE expression