I would like to know the way for specifying a filename dynamically in SQL PLUS.
Say, for example
The file name should be suffixed with a sequence number available from a SEQUENCE object. ( like SPOOL <filename>||seq1.nextval).....
Any idea?
Thank You,
Arul.
