Link to home
Start Free TrialLog in
Avatar of epifanio67
epifanio67

asked on

Oracle: sqlplus: how to send query results to .csv file locally?

Hello Experts,

is there a way to run a query in sqlplus and send the results to a local file?
any format would do....

thx....
ASKER CERTIFIED SOLUTION
Avatar of David VanZandt
David VanZandt
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
wasimibm, the author specified a comma-delimited output (CSV format), which Mike and I address.
sorry its typo, just forgot to replace txt with csv, this thing too would suffice the requirement of the author..!!

author, replace .txt with .csv in my comments..
Avatar of epifanio67
epifanio67

ASKER

thank you for your help...
your suggestions help a lot..

regards,