I’ve recently upgrade to Toad 13.1.0.78, and I’ve started noticing that when I bring up the describe window for some of my larger views, and look at the script on them, the white spacing has become excessive. For example, here’s one small block in a larger view that I have:
WHERE ord . attribute6 IS NOT NULL
AND ord . header_id = line . header_id
AND line . flow_status_code <> ‘CLOSED’
AND line . line_type_id = TYPE . transaction_type_id
AND TYPE . attribute1 = ‘Y’
AND line . open_flag = ‘Y’
AND TYPE . transaction_type_id = type1 . transaction_type_id
AND type1 . LANGUAGE = ‘US’
AND line . ordered_quantity > 0
AND siteuse . site_use_id = ord . deliver_to_org_id
AND siteuse . cust_acct_site_id = acctsite . cust_acct_site_id
AND acctsite . party_site_id = partysite . party_site_id
AND acctsite . cust_account_id = hzacct . cust_account_id
AND hzacct . party_id = party . party_id
AND NVL ( ord . cancelled_flag , ‘N’ ) = ‘N’
AND line . open_flag = ‘Y’
AND ord . open_flag = ‘Y’
–and nvl(msec.attribute1,‘N’) = ‘N’
–and nvl(ord.attribute18,‘No’) = ‘No’
AND line . subinventory = msec . secondary_inventory_name (+)
AND line . ship_from_org_id = msec . organization_id (+)
AND ord . invoice_to_org_id = h . site_use_id
AND h . gl_id_rev = gl . code_combination_id (+)
AND gl . segment3 = f . flex_value
AND f . flex_value_set_id = g . flex_value_set_id
AND g . flex_value_set_name
Here’s the same block as viewed in Toad 11.6.
WHERE ord.attribute6 IS NOT NULL AND ord.header_id = line.header_id AND line.flow_status_code <> 'CLOSED' AND line.line_type_id = TYPE.transaction_type_id AND TYPE.attribute1 = 'Y' AND line.open_flag = 'Y' AND TYPE.transaction_type_id = type1.transaction_type_id AND type1.LANGUAGE = 'US' AND line.ordered_quantity > 0 AND siteuse.site_use_id = ord.deliver_to_org_id AND siteuse.cust_acct_site_id = acctsite.cust_acct_site_id AND acctsite.party_site_id = partysite.party_site_id AND acctsite.cust_account_id = hzacct.cust_account_id AND hzacct.party_id = party.party_id AND NVL (ord.cancelled_flag, 'N') = 'N' AND line.open_flag = 'Y' AND ord.open_flag = 'Y' --and nvl(msec.attribute1,'N') = 'N' --and nvl(ord.attribute18,'No') = 'No' AND line.subinventory = msec.secondary_inventory_name(+) AND line.ship_from_org_id = msec.organization_id(+) AND ord.invoice_to_org_id = h.site_use_id AND h.gl_id_rev = gl.code_combination_id(+) AND gl.segment3 = f.flex_value AND f.flex_value_set_id = g.flex_value_set_id
Anyone have any idea what’s going on here, and how I might be able to get back to normalized white spacing?
Edit: Looks like markdown is removing a lot of the excessive white space that exists. However, you can get an idea of it looking at the spacing that exists around the ‘.’ separating the object aliases and column names. Now imagine instead of it being a single space, it’s anywhere between 3 and 10, and you start to get an idea of what I’m seeing.