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

In how many ways we can link the requisition to purchase order in oracle ebs

 In Oracle E-Business Suite (EBS) R12 / R12.2, a Purchase Requisition can be joined to a Purchase Order across 4 primary levels , depending ...