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(’
GTDG
3
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(’