select a.*,  replace(a.text, chr(10), '') from dba_source a where name = upper('PACKAGE_NAME_OR_FUNCTION_NAME')