How to split the files and save in different paths using spool condition in Oracle 12c.
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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!