I have the following query that does work correctly in SQL*Plus but does not break correctly for the "Sub Total" when run in the Toad Editor. This DOES work correctly in older versions of Toad.
set linesize 200
set pagesize 56
set head on
col "Fac type" format a12
break on report on "Fac Type" skip 2
compute sum label "Sub Total:" of count on "Fac Type"
compute sum label "Grand Total" of count on report
select fac_type_cd "Fac Type",
fac_stat_type_cd "Status",
count (*) "Count"
from fac_str_v1
where fac_stat_type_cd <> 'X'
group by fac_type_cd, fac_stat_type_cd
order by fac_type_cd, fac_stat_type_cd;
WORKAROUND:
None
STATUS:
Waiting for fix in a future version of Toad for Oracle.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center