[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Help in getting data into CSV file
- Subject: Help in getting data into CSV file
- From: Ashish Bhatt <ashish_bhatt@HOTMAIL.COM>
- Date: Mon, 22 Oct 2001 16:55:14 -0700
Hi Peoplesoft and SQR Gurus,
I hope you are doing fine today.
I have in $select_statement all my column names, table name and the condition.
My $select_statement is as below. It returns multiple rows.
let $select_statement = "select
EMPLOYER_APPROVED,PREV_SABB_ELIG_DT,AUDIT_OPRID from PS_AUDIT_ABS_HIST where
AUDIT_STAMP < SYSDATE - 1300;"
I want to run this in SQR and get data in CSV (Comma Separated) file.
In the above statement fields and tables are dynamically created - meaning that
no fix number of columns. The columns comes from ALL_TAB_COLUMNS.
Is it possible in SQR ? Please reply.
Thanks in advance.
Have a nice day and great weekend.
Regards.
Ashish Bhatt.