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: 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;