Category: oracle

set serveroutput on format wrapped; declare my_var long; begin for x in ( select <col> from <table> where … ) loop my_var := dbms_lob.substr( x.<col>, 32000, 1 ); DBMS_OUTPUT.put_line(my_var); end loop; end; / Read more →

declare file_handle utl_file.file_type; begin file_handle := utl_file.FOpen(‘DIRECTORY_NAME’, ‘test.txt’, ‘w’); utl_file.put_line(file_handle, ‘test’); utl_file.FFlush(file_handle); utl_file.FClose(file_handle); end; Read more →