Monday, 6 April 2015

Handling Single Quotes in Column Content

dbms_xmlgen.convert( rtrim( extract( Xmlagg( xmlelement(e,Sq_Sql.Attr_Value) order by Sq_Sql.line_no
             ), '//text()').getclobval() , ','), 1) 

Sq_Sql.Attr_Value , Sq_Sql.line_no are column names

No comments:

Post a Comment