NAME_JOIN

Arguments:

Returns:

Source

Legend: comment string keyword reserved word operator

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