Humble Trader

Wednesday, November 15, 2006

Warehouse Libraries - Package CTL.LIB_NUMBER Specification

  • Package: lib_number
  • Description: A set of library functions and procedures to support number manipulation.
    • Function: cardinal_num
      • Description: Return the cardinal string equivalent of the input number.
      • Parameters:
        • p_number:
          • Datatype: NUMBER
          • Direction: IN
          • Description: The number.
      • Return:
        • Datatype: VARCHAR2
        • Description: Cardinal.
      • Action:
        • Get the last digit
        • Create a cardinal string based on the last digit.
        • Return the cardinal string.

0 Comments:

Post a Comment

<< Home