43.143 TABLE_TO_STRING Function [DEPRECATED]
Oracle recommends that you use the JOIN
and JOIN_CLOB
functions.
Given a a PL/SQL table of type APEX_APPLICATION_GLOBAL
.VC_ARR2
, this function returns a delimited string separated by the supplied separator, or by the default separator, a colon (:).
Syntax
APEX_UTIL.TABLE_TO_STRING (
p_table IN APEX_APPLICATION_GLOBAL.VC_ARR2,
p_string IN VARCHAR2 DEFAULT ':')
RETURN VARCHAR2;
Parameters
Table 43-123 TABLE_TO_STRING Parameters
Parameter | Description |
---|---|
|
String separator. Default separator is a colon (:). |
|
PL/SQL table that is to be converted into a delimited string. |
Example
The following function returns a comma delimited string of contact names that are associated with the provided cust_id
.
create or replace function get_contacts (
p_cust_id in number )
return varchar2
is
l_vc_arr2 apex_application_global.vc_arr2;
l_contacts varchar2(32000);
begin
select contact_name
bulk collect
into l_vc_arr2
from contacts
where cust_id = p_cust_id
order by contact_name;
l_contacts := apex_util.table_to_string (
p_table => l_vc_arr2,
p_string => ', ');
return l_contacts;
end get_contacts;
Parent topic: APEX_UTIL