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: is
     5: 	ret	varchar2(4000);
     6: 	i	binary_integer;
     7: begin
     8: 	ret := '';
     9: 	i := ch_in.first;
    10: 	if i is null
    11: 	then
    12: 		return ret;
    13: 	end if;
    14: 	ret := ch_in(i);
    15: 	i := ch_in.next(i);
    16: 	while i is not null
    17: 	loop
    18: 		ret := ret || sep_in || ch_in(i);
    19: 		i := ch_in.next(i);
    20: 	end loop;
    21: 	return ret;
    22: end;