Main Tables Views Materialized Views Indexes Constraints Triggers Procedures Functions Packages Sequences Java Sources Sanity Check Index DDL scrips
Arguments Source

CHANNEL_NAME_JOIN

DDL script

Arguments:

NameData TypeDefault ValueIn/Out
SEP_INVARCHAR2 IN
CH_INTABLE IN

Returns:

VARCHAR2

Source

Legend: comment string keyword reserved word operator
     1: function
     2: channel_name_join(sep_in in varchar2, ch_in in channel_name_t)
     3: return varchar2
     4: deterministic
     5: is
     6: 	ret	varchar2(4000);
     7: 	i	binary_integer;
     8: begin
     9: 	ret := '';
    10: 	i := ch_in.first;
    11: 
    12: 	if i is null
    13: 	then
    14: 		return ret;
    15: 	end if;
    16: 
    17: 	ret := ch_in(i);
    18: 	i := ch_in.next(i);
    19: 
    20: 	while i is not null
    21: 	loop
    22: 		ret := ret || sep_in || ch_in(i);
    23: 		i := ch_in.next(i);
    24: 	end loop;
    25: 
    26: 	return ret;
    27: end;