min plsql code example
Example: min plsql
--in query use MIN
SELECT MIN(something)
FROM some_table;
--in statements use LEAST (watch out, if there is a null it will return null)
local_variable := LEAST('2', '5', '12', '3');
--Here some examples
LEAST('2', '5', '12', '3')
Result: '12'
LEAST(2, 5, 12, 3)
Result: 2
LEAST('apples', 'applis', 'applas')
Result: 'applas'
LEAST('apples', 'applis', 'applas', null)
Result: NULL