Pages

Showing posts with label SQL Function. Show all posts
Showing posts with label SQL Function. Show all posts

Tuesday, 20 June 2023

COALESCE() Function

 Return the first non-null value in a list.

Example:

SELECT COALESCE(NULL, NULL, NULL, 'value 1', NULL, 'value 2') FROM dual;

Output: value 1

Code Review

 SOLID Principles S – Single Responsibility Principle There should never be more than one reason for a class to change. O – Open-Closed Prin...