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.
Discuss This Question: