• Home
• it.cnr.si.sigla
• sigla-backend
• 6.6.4
• source code
• fnc_ccnconcat.fnc

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

expsigladb.Function.fnc_ccnconcat.fnc Maven / Gradle / Ivy

CREATE OR REPLACE FUNCTION FNC_CCNCONCAT (p_cursor IN  SYS_REFCURSOR, p_separator IN Varchar2 default ',')
  RETURN  VARCHAR2
IS
  l_return  VARCHAR2(32767); 
  l_temp    VARCHAR2(32767);
BEGIN
  LOOP
    FETCH p_cursor
    INTO  l_temp;
    EXIT WHEN p_cursor%NOTFOUND;
    l_return := l_return || p_separator || l_temp;
  END LOOP;
  RETURN LTRIM(l_return, p_separator);
END;
/