[help] how to CREATE FUNCTION to FIND MAXIMUM VALUE WITHOUT TABLE

widiarifki · #1 (**permalink**) 01-19-12, 05:41

Hello everybody, I'm newbie in oracle and still getting started with it..

I need ur help for answering my curiosity..

How can I CREATE FUNCTION to FIND MAXIMUM VALUE FROM SOME NUMBERS I ENTERED AS PARAMETER? WITHOUT USING TABLE?

E.G: I ENTERED AS PARAMETER (10,20,30) AND RESULT FROM THE FUNCTION CREATED IS "30"?

HOW CAN I?

Please clarify my doubt.

Many Thanks.

tonkuma · #2 (**permalink**) 01-19-12, 07:55

Why not use GREATEST SQL function?

Quote:

About SQL Functions

SQL functions are built into Oracle Database and are available for use in various
appropriate SQL statements. Do not confuse SQL functions with user-defined
functions written in PL/SQL.