Could someone help here ?
requirement is : SQL*PLUS command.
I know the following way it is not doable from SQL*Plus
but is there any other way to achieve same from SQL*Plus?
Is it possible to generate files using spool option assiging
a column value as file name as per following scenario ?
SPOOL C:\'to_char(sysdate,'YYYYMMDD'||'_'||org_name||'.txt' <--- is it possible?
---data inside table is
id name org_name
---- ---------- -------------
1 abc org_1
2 def org_1
3 ghi org_2
4 jkl org_2
want to generate each file for each org_name separately on a given path.
So above will generated two file like: