ID_JOIN

Arguments:

Returns:

Source

Legend: comment string keyword reserved word operator

     1: FUNCTION
     2: ID_JOIN(sep_in IN VARCHAR2, ugi_in IN user_group_id_t)
     3: RETURN VARCHAR2
     4: deterministic
     5: IS
     6: 	ret	VARCHAR2(4000);
     7: 	i	BINARY_INTEGER;
     8: BEGIN
     9: 	ret := '';
    10: 	i := ugi_in.FIRST;
    11: 
    12: 	IF i IS NULL
    13: 	THEN
    14: 		RETURN ret;
    15: 	END IF;
    16: 
    17: 	ret := ugi_in(i);
    18: 	i := ugi_in.NEXT(i);
    19: 
    20: 	WHILE i IS NOT NULL
    21: 	LOOP
    22: 		ret := ret || sep_in || ugi_in(i);
    23: 		i := ugi_in.NEXT(i);
    24: 	END LOOP;
    25: 
    26: 	RETURN ret;
    27: END;