How to write an anonymous PL/SQL function and use it in your SQL statement
Have you ever encountered a situation when you were in the middle of writing a SQL query and thought, “if […]
SQL
Percentage calculations using SQL Window Functions
Sometimes you have the requirement to calculate percentages on some values of your data. There are multiple ways of doing