Sqlplus output format sorting

Sqlplus output display adjustment SQL> set linesize 32767
Set the linesize to the maximum. You can try 99999 first and the system will prompt that the value is out of the range.
SQL> set heading off
In fact, the display effect is still unsatisfactory. It is not as automatic table output as MySQL, and needs to be improved.

Set echo on/off: whether to display the commands to be executed in the script
Set feedback on/off indicates whether to display the number of rows returned after select results
Set linesize n sets the maximum number of characters displayed in a row
Set termout on/off whether to output the result on the screen when executing the script. If spool arrives at the file, you can disable it.
Set heading on/off whether to display the column name of the query result. If it is set to off, it will be replaced by a blank row. If you want to remove this blank row, you can use set pagesize 0
Set pagesize n sets the number of rows per page. If n is set to 0, all headings, page breaks, titles, the initial blank line, and other formatting information are not displayed.
Set trimspool on/off whether to remove the blank characters at the end of the row in the output result when the spool to the file. You can use this parameter to remove the previous delimiter. trimout corresponds to this parameter, the latter is used for screen output.
Whether set trimout On/Off removes the white space at the end of the output result line on the screen