Wednesday, 9 February 2022

How to Spool the data in SQL developer tool

set SERVEROUTPUT ON SIZE 1000000

 set headsep off

set pagesize 0

set trimspool on

set lines 240

spool E:\prebill.csv

select trx_number, trx_date from ra_customer_trx_all where trunc(trx_date) between trunc(sysdate-1) and trunc(sysdate);

spool off;


Note:-  Select all the script and press F5, it will generate the output in E Drive with file name as prebill.csv

No comments:

Post a Comment

Uploading PO Attachments from EBS to FTP Server

 create or replace PROCEDURE xx_upload_po_attachment(errbuff out varchar2, retcode out number)  IS CURSOR cur_new_attmt IS    select ponumbe...