Toad World® Forums

Execute as Script output missing an output line.

SELECT ‘SELECT tablespace_name, COUNT(*)
FROM dba_segments
WHERE tablespace_name IN (’ FROM DUAL;

When executed as a script, Output tab is missing the “WHERE tablespace_name IN (” line:

Time Start: 8/13/2013 8:24:30 AM

‘SELECTTABLESPACE_NAME,COUNT(*)FROMDBA_SEGMENTSWHERETABLESPACE_NAMEIN(’

SELECT tablespace_name, COUNT(*)
FROM dba_segments

1 row selected.
Time End: 8/13/2013 8:24:30 AM
Elapsed Time for Script Execution: 387 msecs

Grid tab show correct result:

SELECT tablespace_name, COUNT(*)
FROM dba_segments
WHERE tablespace_name IN (

Missing closing parens on IN list might be the cause ???

From: droeschley_109 [mailto:bounce-droeschley_109@toadworld.com]

Sent: Tuesday, August 13, 2013 9:17 AM

To: toadoraclebeta@toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] Execute as Script output missing an output line.

Execute as Script output missing
an output line.

Thread created by droeschley_109

SELECT 'SELECT tablespace_name, COUNT(*)

FROM dba_segments

WHERE tablespace_name IN (’ FROM DUAL;

When executed as a script, Output tab is missing the “WHERE tablespace_name IN (” line:

Time Start: 8/13/2013 8:24:30 AM

‘SELECTTABLESPACE_NAME,COUNT(*)FROMDBA_SEGMENTSWHERETABLESPACE_NAMEIN(’

Should be fixed for the next beta.

From: droeschley_109 [mailto:bounce-droeschley_109@toadworld.com]

Sent: Tuesday, August 13, 2013 10:17 AM

To: toadoraclebeta@toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] Execute as Script output missing an output line.

Execute as Script output missing
an output line.

Thread created by droeschley_109

SELECT 'SELECT tablespace_name, COUNT(*)

FROM dba_segments

WHERE tablespace_name IN (’ FROM DUAL;

When executed as a script, Output tab is missing the “WHERE tablespace_name IN (” line:

Time Start: 8/13/2013 8:24:30 AM

‘SELECTTABLESPACE_NAME,COUNT(*)FROMDBA_SEGMENTSWHERETABLESPACE_NAMEIN(’