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