Warehouse Libraries - lib_string_h.sql

-- ------------------------------------------------------------------------- -- -- -- -- Title: lib_string_h.sql -- -- Author: Steve Roach -- -- Date: 12-SEP-2006 -- -- Version: 01.00 -- -- -- -- Description: Container for all procedures and functions relating to -- -- the String Library. -- -- -- -- Procedures: -- -- ------------------------------------------------------------------------ -- -- Function: ltrim_chr -- -- -- -- Strips all of the specified character from the start of the -- -- string. -- -- -- -- p_string IN VARCHAR2 - String to be stripped. -- -- p_chr IN VARCHAR2 - Character strip target. -- -- RETURN VARCHAR2 - Stripped string. -- -- ------------------------------------------------------------------------ -- -- Function: count_chr -- -- -- -- Returns a count of the total number of target character in the -- -- string. -- -- -- -- p_string IN VARCHAR2 - String to be searched. -- -- p_chr IN VARCHAR2 - Character search target. -- -- RETURN VARCHAR2 - Count of target character in -- -- string. -- -- -- -- ------------------------------------------------------------------------- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- 12-SEP-06 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- -- Package header definition. CREATE OR REPLACE PACKAGE lib_string AS FUNCTION ltrim_chr( p_string IN VARCHAR2, p_chr IN VARCHAR2) RETURN VARCHAR2; FUNCTION count_chr( p_string IN VARCHAR2, p_chr IN VARCHAR2) RETURN NUMBER; END lib_string; / SHOW ERRORS