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....
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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..
author, replace .txt with .csv in my comments..
ASKER
thank you for your help...
your suggestions help a lot..
regards,
your suggestions help a lot..
regards,