PostgreSQLOracle/PLSQL
To_char (numeric)SELECT statement
To_char (date/time)To_char
Data TypesTo_date
CREATE tableRow_number
CREATE sequenceJulian date
String functionsPLJSON – JSON extension for PL/SQL
Mathematical functionsJoins
Formatting functions5 ways to delete duplicate records Oracle
Date/Time functionsDifference between TRUNCATE and DELETE
XML functionsDifference between TRUNC and ROUND
JSON functionsDifference between UNION and UNION ALL clause
BYTEA/BLOB functionsDifference between DECODE and CASE
Array functionsFind nth highest salary
Range functionsDUAL table
Aggregate Functions5 different ways to test Ref Cursor results
Window Functions5 different ways to load flat file
Conditional Expression5 different ways to delete duplicate records
CASE ExpressionCASE expression
%d bloggers like this: