Hi guys,
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?
SCENARIO
========
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?
select id,name,org_name
from test_org;
spool off
---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:
'C:\test\20070910_org_1.txt'
'C:\test\20070910_org_2.txt'
Thanking you