How to save two different files using spool condition in Oracle 12c

10 pts.
Tags:
Oracle 12c
Spool files
Hi,
Please clarify on the below code:
How to split the files and save in different paths using spool condition in Oracle 12c.
For example:
If I run the query like 'select * from employee where emp_salary = '2000'...if the employee whose having salary 2000 file should save in one path. If the employee whose having salary >2000 that file should save in another path   as a two different files.. So, please send me the query to do the above condition using Oracle SQL query.


Software/Hardware used:
ORACLE 12c
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: