create or replace package &tq84_prefix.string_op as

-- vi: ft=sql

--

--

function strtok (str in varchar2, delimiter in varchar2) return &tq84_prefix.varchar2_t;

function grep_re(str in varchar2, regexp in varchar2) return &tq84_prefix.varchar2_t;

-- sprintf related -- {

--

function sprintf(format varchar2, parms in &tq84_prefix.varchar2_t) return varchar2;

function sprintf(format varchar2, parm_01 varchar2 ) return varchar2;

function sprintf(format varchar2, parm_01 varchar2, parm_02 varchar2 ) return varchar2;

function sprintf(format varchar2, parm_01 varchar2, parm_02 varchar2, parm_03 varchar2 ) return varchar2;

function sprintf(format varchar2, parm_01 varchar2, parm_02 varchar2, parm_03 varchar2, parm_04 varchar2 ) return varchar2;

function sprintf(format varchar2, parm_01 varchar2, parm_02 varchar2, parm_03 varchar2, parm_04 varchar2, parm_05 varchar2 ) return varchar2;

function sprintf(format varchar2, parm_01 varchar2, parm_02 varchar2, parm_03 varchar2, parm_04 varchar2, parm_05 varchar2, parm_06 varchar2) return varchar2;

-- }

-- printf related -- {

procedure printf(format varchar2, parms &tq84_prefix.varchar2_t);

procedure printf(format varchar2, parm_01 varchar2 );

procedure printf(format varchar2, parm_01 varchar2, parm_02 varchar2 );

procedure printf(format varchar2, parm_01 varchar2, parm_02 varchar2, parm_03 varchar2 );

procedure printf(format varchar2, parm_01 varchar2, parm_02 varchar2, parm_03 varchar2, parm_04 varchar2 );

procedure printf(format varchar2, parm_01 varchar2, parm_02 varchar2, parm_03 varchar2, parm_04 varchar2, parm_05 varchar2 );

procedure printf(format varchar2, parm_01 varchar2, parm_02 varchar2, parm_03 varchar2, parm_04 varchar2, parm_05 varchar2, parm_06 varchar2);

-- }

function is_number(str varchar2) return boolean;

end &tq84_prefix.string_op;

/

show errors