Hi all
I need a help.
1) I want to spool Sql and save file from output
2) I want to remove SQL> in Spool
For Example
my spool file should be <Value of "Case_no"_ "F_P"> TBD092019_Fail or TBD092019_Pass.log
Set echo on
select 'TBD092019' as "Case_no",
case when count(*) > 1 then 'Fail'
when count(*) = 1 the 'Pass' End "F_P"
from(
select Employee_id, Employee_name , count(*)
From Emp
Group by Employee_id, Employee_name)
Thanks for all your help