Currently I'm working in oracle to sql migration
I could see dbms_lob.createtemporary() in oracle. I want to know what is alternative for this function in sql and need alternative for few statement
sample code
vResult CLOB;
vDelim VARCHAR2(4);
CURSOR curC Is// need alternative
vFld curC %ROWTYPE;
--------------------------
BEGIN
vDelim := NULL;
vDelim := ' ';
vResult := '';
dbms_lob.createtemporary(vResult, TRUE); // need alternative
//from need alternative+++++
FOR vFld IN curC LOOP
EXIT WHEN curC%NOTFOUND ;
DBMS_LOB.APPEND(vResult ,vDelim||vFld.depend_link);
END LOOP;
//end need alternative+++++
RETURN vResult;
END;