CHANNEL_NAME_JOIN
DDL scriptArguments:
| Name | Data Type | Default Value | In/Out |
|---|
| SEP_IN | VARCHAR2 | | IN |
| CH_IN | TABLE | | IN |
Returns:
VARCHAR2Source
Legend: 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;