Return
-
Title
Setting LINESIZE X and WRAP OFF does not give the same effect as SQL PLUS. -
Description
When user tries to run the following code, as script (F5), the display result in TOAD Editor is not the same as SQL PLUS.
SET LINESIZE 1000
SET WRAP OFF
SELECT * FROM <some table>;
In SQL PLUS, extra columns that do not fit on the screen get truncated. In TOAD, columns are wrapped regardless.
-
Resolution
To keep columns and rows from being wrapped, execute your query as script (F9).