Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2012
    Posts
    6

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

    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.

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    Why not use GREATEST SQL function?

    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.

  3. #3
    Join Date
    Jan 2012
    Posts
    6
    Quote Originally Posted by tonkuma View Post
    Why not use GREATEST SQL function?
    Yep, use greatest.
    its work. btw, i've never heard and knew this function before.

    Many Thanks.
    Regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •