Remove SQLPlus Dashed Lines: Quick Guide
To remove the dashed lines in the SQLPlus query result, you can use the following method:
- To control the number of characters displayed on each line when running a sqlplus session, you can set the linesize parameter before executing the query. Setting linesize to a lower value can prevent the display of dashed lines. For example:
- Set the line size to 100.
- This will limit the number of characters output per line to 100, reducing the chance of dashed lines appearing.
- You can turn off the underline feature in a sqlplus session by using the SET UNDERLINE OFF command, which will prevent dashed lines from being displayed.
- Turn off underline.
- This will disable the default underscore feature of sqlplus, no longer displaying dotted lines in query results.
By using the above-mentioned method, you can remove the dashed lines from the query results in sqlplus.