# Toad spool behaves differently than sqlplus

**URL:** <https://forums.toadworld.com/t/toad-spool-behaves-differently-than-sqlplus/60537>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [February 6, 2025, 12:58am UTC](https://forums.toadworld.com/t/toad-spool-behaves-differently-than-sqlplus/60537 "2025-02-06T00:58:53Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![raymond.leung](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/raymond.leung/32/12511_2.png) [@raymond.leung](https://forums.toadworld.com/u/raymond.leung)\
**Post date:** [February 6, 2025, 12:58am UTC](https://forums.toadworld.com/t/toad-spool-behaves-differently-than-sqlplus/60537/1 "2025-02-06T00:58:53Z")

</div>

Given this test script:

```auto
SET VERIFY OFF
SET HEADING OFF
SET FEEDBACK OFF
SET ECHO OFF
SET LINESIZE 2000
SET PAGESIZE 0
SET TRIMSPOOL ON
SET TERM OFF

SPOOL test.out

select 'query1' a from dual;
select 'query2' a from dual;
select 'query3' a from dual;

Spool off;
exit;

```

Running in Toad produces this in the test.out file:

```auto
query1

query2

query3

```

Whereas running in sqlplus produces this in the test.out file:

```auto
query1
query2
query3

```

I'm using Toad 17.0.341.1977

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [February 6, 2025, 1:19pm UTC](https://forums.toadworld.com/t/toad-spool-behaves-differently-than-sqlplus/60537/2 "2025-02-06T13:19:36Z")

</div>

Thanks, I've logged it in our bug tracking system.
