What is the defualt value of NUMFORMAT in SQL*Plus, and how can I explicitly re-set NUMFORMAT to it? I have one script that displays a lots of small integer columns. To avoid writing COLUMN commands for all of them, I used
SET NUMFORMAT 999
That works fine, but if I want to use another script later in the same session, how can I restore the default? If I say
SET NUMFORMAT TM
then it displays integers without a decimal point, and other numbers with a decimal point, put it uses 64 characters, no matter what NUMWIDTH is. How can I tell SQL*Plus to use the format it was originally using (decimal point only when needed, digits after the decimal point rounded if the value won't fit in NUMWIDTH)?