oracle spool have any settings to remove default lst extension?

Question

In oracle spool, if we not specify the spool file extension, we get "file.lst", any settings to get file?

score 0 · Answer 1 · answered Mar 29 '21 at 15:01

0

Sure. Just specify the fully qualified name:

spool myfile.txt

answered Mar 29 '21 at 15:01

EdStevens

3,708
2
10
18

which I mean is to get a file without any extension, just ```myfile``` – jie Mar 31 '21 at 13:43
No way that I've found. Why would you even want to have a file without an extension? – EdStevens Mar 31 '21 at 15:26

score 0 · Accepted Answer · answered Apr 03 '21 at 19:42

No, that seems not possible. The documentation says

If you do not specify an extension, SPOOL uses a default extension (LST or LIS on most systems). The extension is not appended to system files such as /dev/null and /dev/stderr.

https://docs.oracle.com/en/database/oracle/oracle-database/19/sqpug/SPOOL.html#GUID-61492052-ECCB-45C8-AF94-AB9794C60BEA

oracle spool have any settings to remove default lst extension?

2 Answers2