max value function.

Hi all !

Is there any Business Function to find out the maximum value of a =
particular field in a Table?

Regards,

Anto

Use SQL.

select max(my_field) from proddta.my_table;
or
select * from proddta.my_table where my_field = select max(my_field) from
proddta.my_table;

Hope, it helps.

Regards, Alex Shevchenko

B7332 SP17, Oracle 8.1.7, Solaris production
XE SP18 Oracle 8.1.7, Solaris test