# Different display when run in TOAD and SQLPLUS

**URL:** <https://forums.toadworld.com/t/different-display-when-run-in-toad-and-sqlplus/60391>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [January 3, 2025, 10:08am UTC](https://forums.toadworld.com/t/different-display-when-run-in-toad-and-sqlplus/60391 "2025-01-03T10:08:12Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![kennethyp.tse](https://avatars.discourse-cdn.com/v4/letter/k/ce73a5/32.png) [@kennethyp.tse](https://forums.toadworld.com/u/kennethyp.tse)\
**Post date:** [January 3, 2025, 10:08am UTC](https://forums.toadworld.com/t/different-display-when-run-in-toad-and-sqlplus/60391/1 "2025-01-03T10:08:13Z")

</div>

When run the following script

col job\_name for a15  
col owner for a8  
col state for a10  
col start\_date for a18  
col job\_name for a15  
col job\_action for a60  
set linesize 200  
set echo on

spool scheduler\_job\_status.log

select job\_name, owner, state, enabled, to\_char(start\_date,'DD-MON-YY HH24:MI:SS') as start\_date,job\_action from dba\_scheduler\_jobs where job\_name = 'LOCK\_USER\_JOB';

spool off

TOAD output :

![toad](https://global.discourse-cdn.com/quest/original/3X/5/5/55a55c021f30b1f406b77b033cdf4d3688c4d481.png)

where sqlplus output:

![sqlplus](https://global.discourse-cdn.com/quest/original/3X/b/1/b1f87c1f83ee057f48b06663f3a0e2980484f85f.png)

TOAD seems warp the ‘JOB\_ACTION’ wording to the beginning of next new line while sqlplus ‘JOB\_ACTION’ warp within it own column which is what I expected.

How could I change the behaviour of ‘TOAD’ to ‘SQLPLUS’?

My TOAD version is :  
Toad for Oracle Xpert Edition (64-bit)  
Add-Ons: DB Admin Module  
17.1.717.3711

---

<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:** [January 3, 2025, 1:30pm UTC](https://forums.toadworld.com/t/different-display-when-run-in-toad-and-sqlplus/60391/2 "2025-01-03T13:30:24Z")

</div>

I think it's a bug. I see that if the text is just too long, Toad wraps it the same way as SQLPlus. It just doesn't handle line feeds the same way SQLPlus does.

For example, this SQL returns long text the wraps the same way SQL Plus does.

```auto
col job_name for a15
col owner for a8
col state for a10
col start_date for a18
col job_name for a15
col job_action for a60
set linesize 200
set echo on

spool scheduler_job_status.log

select job_name, owner, state, enabled, to_char(start_date,'DD-MON-YY HH24:MI:SS') as start_date, 
       '1234567890 ' || '1234567890 ' ||'1234567890 ' ||'1234567890 ' ||'1234567890 ' ||
       '1234567890 ' ||'1234567890 ' ||'1234567890 '||'1234567890 'as job_action 
from dba_scheduler_jobs;

spool off

```

---

<div class="post-metadata">

**Author:** ![kennethyp.tse](https://avatars.discourse-cdn.com/v4/letter/k/ce73a5/32.png) [@kennethyp.tse](https://forums.toadworld.com/u/kennethyp.tse)\
**Post date:** [January 6, 2025, 8:01am UTC](https://forums.toadworld.com/t/different-display-when-run-in-toad-and-sqlplus/60391/3 "2025-01-06T08:01:05Z")

</div>

Dear John,

Thank for your reply. What additonal steps do I need to get it fixed or I just wait for patching release?

Tks/Kenneth

---

<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:** [January 6, 2025, 1:28pm UTC](https://forums.toadworld.com/t/different-display-when-run-in-toad-and-sqlplus/60391/4 "2025-01-06T13:28:07Z")

</div>

I've logged the bug in our internal bug tracking system. I can't provide an ETA for the fix.

The only workaround I can offer would be for you use the REPLACE function on your SQL, replacing line feeds with spaces, something like the following:

```auto
SELECT job_name, owner, state, enabled,
       TO_CHAR (start_date, 'DD-MON-YY HH24:MI:SS') AS start_date,
       replace(replace(job_action, CHR(10), ' '), CHR(13), null) as job_action
  FROM dba_scheduler_jobs
WHERE job_name = 'LOCK_USER_JOB';

```
