[How to] How to call a function defined in the package

The following sql is to call a function defined in the package

declare

  outVal number;
begin
   -- Call the function
   outVal := mypackage.myfunction (100);
end;

Howto: Find the biggest value in the column

This article teaches you how to get the biggest value in the columns in the same table.

It could be done by the built-in function GREATEST

However, it does not work when there are null values in the column.

You may use NVL function as a work around.