cat file | awk '{printf"(t.who = "'"%s",$1}'
Regards
ADI
awk '{print "(t.who = \x27" $1 "\x27 and trunc(ymddate) = to_date(\x27" $7"-"$8"-"$NF"\x27,\x27mon-dd-yyyy\x27)) or"}' file
1 Like