# Formatting Script Output

**URL:** <https://forums.toadworld.com/t/formatting-script-output/9666>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [July 6, 2010, 1:14pm UTC](https://forums.toadworld.com/t/formatting-script-output/9666 "2010-07-06T13:14:07Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![jodi.siebenberg\_359](https://avatars.discourse-cdn.com/v4/letter/j/3ec8ea/32.png) [@jodi.siebenberg\_359](https://forums.toadworld.com/u/jodi.siebenberg_359)\
**Post date:** [July 6, 2010, 1:14pm UTC](https://forums.toadworld.com/t/formatting-script-output/9666/1 "2010-07-06T13:14:07Z")

</div>

Hi, when running a sql as a script, the output is wrapping, the date is putting a character on a separate line for each character and the select statement is not being returned.

Does anyone know where I would change these settings? I am currently running vers 8.6.1 and I had all this formatting correct prior to a hard drive crash.

Thanks so much!!

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [July 6, 2010, 1:14pm UTC](https://forums.toadworld.com/t/formatting-script-output/9666/2 "2010-07-06T13:14:07Z")

</div>

Same as sql plus: add set linesize 256 to your script

There are also options in various versions of Toad to control this – but  
the interface has changed over the years – so you’ll need to do a  
search in options

---

<div class="post-metadata">

**Author:** ![christopher.tryonhat](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/christopher.tryonhat/32/139_2.png) [@christopher.tryonhat](https://forums.toadworld.com/u/christopher.tryonhat)\
**Post date:** [July 6, 2010, 1:14pm UTC](https://forums.toadworld.com/t/formatting-script-output/9666/3 "2010-07-06T13:14:07Z")

</div>

Jodi,

Have you tried to

set linesize 1000

Or some other long number?

chris

---

<div class="post-metadata">

**Author:** ![jodi.siebenberg\_359](https://avatars.discourse-cdn.com/v4/letter/j/3ec8ea/32.png) [@jodi.siebenberg\_359](https://forums.toadworld.com/u/jodi.siebenberg_359)\
**Post date:** [July 6, 2010, 1:41pm UTC](https://forums.toadworld.com/t/formatting-script-output/9666/4 "2010-07-06T13:41:24Z")

</div>

Thanks! I did the search and wasn’t able to find it…

I can add the linesize, headers and etc to each script, but, I had it formatted prior to my crash and it wasn’t neccessary to add each time.

Any other suggestions, it’s making my life miserable… well, maybe not my life… just my script output… 🙂

Thanks again.

Jodi

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [July 6, 2010, 1:41pm UTC](https://forums.toadworld.com/t/formatting-script-output/9666/5 "2010-07-06T13:41:47Z")

</div>

Increase your linesize in the environment variables at the top of the script

i.e.

set linesize 250

or something larger to accomodate the length of your data line.

see excerpt from link below. Best regards and good luck, let me know if you  
need any more help.

Gene

---

<div class="post-metadata">

**Author:** ![pickedaname](https://avatars.discourse-cdn.com/v4/letter/p/f6c823/32.png) [@pickedaname](https://forums.toadworld.com/u/pickedaname)\
**Post date:** [August 20, 2013, 11:58am UTC](https://forums.toadworld.com/t/formatting-script-output/9666/6 "2013-08-20T11:58:16Z")

</div>

Wow guys, really??? It took me all but 3 minutes of searching through toad options to find her answer. 3 years later, in case anyone ELSE needs this, I have version 9 and 10 and it’s the same for both.

Go to Toad Options\>Execute/Compile\>Login Scripts. glogin.sql should be defaulting to your sqlplus editor login file. click it’s edit button and enter SET LINESIZE 1000 (or whatever width) there. Save that file, click apply and Ok. Changes are immediate. I would imagie that if, for whatever reason, that file is not there, then you could create a login file in toads working folder and use the OTHER edit button in like manner. Just wow

---

<div class="post-metadata">

**Author:** ![mhughes60](https://avatars.discourse-cdn.com/v4/letter/m/e36b37/32.png) [@mhughes60](https://forums.toadworld.com/u/mhughes60)\
**Post date:** [January 22, 2014, 10:27am UTC](https://forums.toadworld.com/t/formatting-script-output/9666/7 "2014-01-22T10:27:18Z")

</div>

Is there a way to get around the 2000 linesize maximum limit in Toad? We have a large dashboard that requires a 2500 linesize max that we run with SQL Plus, but my coworker’s older machine with SQL Plus is being upgraded soon, and we will not have access to SQL Plus to run our batch jobs. I can manually run our script with the SQL Plus feature on our Toad, but we would like to keep it automated so we can run it overnight.

Thanks.

Mike

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [January 22, 2014, 10:33am UTC](https://forums.toadworld.com/t/formatting-script-output/9666/8 "2014-01-22T10:33:17Z")

</div>

Why not use the Quest Script Runner (part of Toad). It’s our lightweight editor minus like 80% of features that’s perfect for running scripts - and it supports like 99% of SQL Plus scripting syntax.

---

<div class="post-metadata">

**Author:** ![GTDG](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gtdg/32/140_2.png) [@GTDG](https://forums.toadworld.com/u/GTDG)\
**Post date:** [January 22, 2014, 10:48am UTC](https://forums.toadworld.com/t/formatting-script-output/9666/9 "2014-01-22T10:48:05Z")

</div>

I’m not sure there is a technical reason for it but I can take a look and see if there’s a little magic left in my hat

**From:** Bert Scalzo [[mailto:bounce-Bert\_Scalzo@toadworld.com](mailto:bounce-Bert_Scalzo@toadworld.com)]

**Sent:** Wednesday, January 22, 2014 1:33 PM

**To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com)

**Subject:** RE: [Toad for Oracle - Discussion Forum] Formatting Script Output

**[RE: Formatting Script Output](http://www.toadworld.com/products/toad-for-oracle/f/10/p/9486/43823.aspx#43823)**

Reply by Bert Scalzo

Why not use the Quest Script Runner (part of Toad). It’s our lightweight editor minus like 80% of features that’s perfect for running scripts - and it supports like 99% of SQL Plus scripting  
syntax.

To reply, please reply-all to this email.

[Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/f/10/t/9486.aspx?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad for Oracle - General](http://www.toadworld.com/products/toad-for-oracle/f/10.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Discussion Forum

[Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/p/9486/43823.aspx?AbuseContentId=c12f284c-5958-49e5-b1ae-3004e0a60aff&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
this post as spam/abuse.

![](http://gyk.r.mailjet.com/o/04j0/6f550b46/p32hqj6e.gif)

---

<div class="post-metadata">

**Author:** ![mhughes60](https://avatars.discourse-cdn.com/v4/letter/m/e36b37/32.png) [@mhughes60](https://forums.toadworld.com/u/mhughes60)\
**Post date:** [January 28, 2014, 11:40am UTC](https://forums.toadworld.com/t/formatting-script-output/9666/10 "2014-01-28T11:40:50Z")

</div>

I use Toad for several overnight batch jobs but it will not allow a linesize of over 2000. I can manually run a script with a linesize of 2500 using the Execute via SQL\*Plus in Toad, but it will not run automatically when the sql file is called from a script.
