SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Output with delimiter

user550686Mar 17 2009 — edited Mar 17 2009

I have below query which is taking long time to run cos of huge data.So I want to run this in server to print the output to a temporary variable by seperating the columns using delimiter,so that i can export it later to excel.Can anyone pls help me with the script

select invoice_id,
invoice_num,
vendor_id,
invoice_amount,
source,
voucher_num
from ap_invoices_all

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 14 2009

Added on Mar 17 2009

6 comments

1,208 views