Toad for Oracle 10.1 is unable or cannot successfully Format raw scripts from Oracle session runs i.e. code or SQL statements with no spaces. When I try to format it, it remains the same, and no changes were made, nothing happens.
Example:
==================================================================
select /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor
_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitor
ing */ count(*),sum(sys_op_opnsize("DELETED_AT")),sum(sys_op_opnsize("SDE_DELETES_ROW_ID")),count(distinct "SDE_STATE_ID"),sum(sys_op_opnsize("SDE_STATE_ID")),substrb(dump(min("SDE_STATE_ID"),
16,0,32),1,120),substrb(dump(max("SDE_STATE_ID"),16,0,32),1,120)
from "LAND"."D56" t
==================================================================
Upgrade to Toad for Oracle 10.5.0. The new QP5 version can now handle raw scripts. See example below.
Here is the result when the above statement was formatted using Toad 10.5.0.41:
==================================================================
/* Formatted on 4/26/2010 5:00:40 PM (QP5 v5.149.1003.31008) */
SELECT /*+ no_parallel(t) no_parallel_index(t) dbms_stats cursor
_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitor
ing */
COUNT (
*),
SUM (sys_op_opnsize ("DELETED_AT")),
SUM (sys_op_opnsize ("SDE_DELETES_ROW_ID")),
COUNT (DISTINCT "SDE_STATE_ID"),
SUM (sys_op_opnsize ("SDE_STATE_ID")),
SUBSTRB (DUMP (MIN ("SDE_STATE_ID"),
16,
0,
32), 1, 120),
SUBSTRB (DUMP (MAX ("SDE_STATE_ID"),
16,
0,
32), 1, 120)
FROM "LAND"."D56" t
==================================================================
