How to display to terminal in SQLPLUS the column of a row with the width of the max value of the data within that column

I was wondering if this could be done without the COLUMN FORMAT.

Current example:

TABLESPACE_NAME                BIG DATAFILE_NAME
------------------------------ --- -------------------------------------------------------------------------------------------------------------------
STORETABS                      NO  C:\ORACLE\APP\ASUH\ORADATA\TESTORCL\STORETABS_01.DBF
STORETABS                      NO  C:\ORACLE\APP\ASUH\ORADATA\TESTORCL\STORETABS_02.DBF

Notice the header "-" lines are extended all the way out to match the varchar(n) value defined.

Is there a SQLPLUS SET command that will auto adjust the column width to either the size of the column header or the size of the max data within the column?

I want it to look like this:

TABLESPACE_NAME  BIG DATAFI开发者_如何学CLE_NAME
---------------- --- -----------------------------------------------------
STORETABS        NO  C:\ORACLE\APP\ASUH\ORADATA\TESTORCL\STORETABS_01.DBF
STORETABS        NO  C:\ORACLE\APP\ASUH\ORADATA\TESTORCL\STORETABS_02.DBF

If not by the size of the column header, adjusting to the max size of the data is more desired.

---

No, there is no such setting.

There can't be such a setting, because SQL*Plus fetches arraysize (default of which is 15, I believe) records at a time. So, if after 15 records another longer record is fetched, the -------.... is already printed/written, leaving no chance to SQL*Plus to adjust it.

arraysize is the number set with set arraysize n.