If I execute the following:
show linesize
SELECT ‘SELECT tablespace_name, COUNT(*)
FROM dba_segments
WHERE tablespace_name IN (’ x
FROM DUAL
;
SELECT ‘1234567890123456789012345678901234567890
123456789012345678901234567890123456789’ x FROM dual;
The script output has the last line duplicated:
Time Start: 10/24/2014 9:47:05 AM
linesize 80
X
SELECT tablespace_name, COUNT(*)
FROM dba_segments
WHERE tablespace_name IN (
WHERE tablespace_name IN (
1 row selected.
X
1234567890123456789012345678901234567890
123456789012345678901234567890123456789
123456789012345678901234567890123456789
1 row selected.
Time End: 10/24/2014 9:47:05 AM
Elapsed Time for Script Execution: 323 msecs
Has something to do with the length of output - if under 80 or over 82, it doesn’t duplicate.
This only happens on Execute as Script, not when I Execute Statement at Caret.
Problem has existed for a few GA releases (but apparently I’m the only one that keeps running into it).