Remove SQLPlus Dashed Lines: Quick Guide

To remove the dashed lines in the SQLPlus query result, you can use the following method:

  1. 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:
  2. Set the line size to 100.
  3. This will limit the number of characters output per line to 100, reducing the chance of dashed lines appearing.
  4. 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.
  5. Turn off underline.
  6. 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.

bannerAds