const g_default_separator

g_default_separator constant varchar2(1):=','

function csv_to_array

function csv_to_array(
    p_csv_line in varchar2,
    p_separator in varchar2:=g_default_separator
) return t_str_array

convert CSV line to array of values

function array_to_csv

function array_to_csv(
    p_values in t_str_array,
    p_separator in varchar2:=g_default_separator
) return varchar2

convert array of values to CSV

function get_array_value

function get_array_value(
    p_values in t_str_array,
    p_position in number,
    p_column_name in varchar2:=null
) return varchar2

get value from array by position

function clob_to_csv

function clob_to_csv(
    p_csv_clob in clob,
    p_separator in varchar2:=g_default_separator,
    p_skip_rows in number:=0
) return t_csv_tab

convert clob to CSV