Results 1 to 2 of 2

Thread: Functions

  1. #1
    Join Date
    Feb 2004
    Posts
    5

    Unanswered: Functions

    WHAT IS THE SYNTAX FOR PL/SQL FUNCTIONS??

  2. #2
    Join Date
    Nov 2003
    Posts
    65

    Lightbulb Re: Functions

    i believe its something like this:
    Code:
    FUNCTION calc_sales
       (company_id_in IN company.company_id%TYPE,
        status_in IN order.status_code%TYPE := NULL)
    RETURN NUMBER;
    hope that helps...


    Originally posted by dbkid
    WHAT IS THE SYNTAX FOR PL/SQL FUNCTIONS??

Posting Permissions

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