AND (o.AGENCY = l.AGENCY(+))
But this is excessive in my view…
AND ( ( ( ( ( (o.VIOLATION_DT >= TO_DATE (‘20060701000000’, ‘YYYYMMDDHH24MISS’)
AND INSTR (o.INFRINGEMENT_NO, ‘#’) = ‘0’)
AND o.INPUT_TYPE = ‘1A’)
l.LOCATION_CD || ’ - ’ || l.NAME_1 || ', ’ || l.NAME_2) <>
AND o.INPUT_TYPE = ‘1A’)
Thanks in advance
Hi Debbie,
I think this should be a CR incident with the TOAD developers, but I am getting a little annoyed at the excessive amount of open and close brackets TOAD generates on queries.
I would place say 5-10 conditions (where conditions) on a query in design mode and look at the code… suddenly there is like 5 or more open and close brackets and it’s hard to read the code.
ie:
These are the main primary indexes on my tables… fine I can live with the designer placing them in the WHERE clause where I would have expected them to be placed as JOINS (nudge nudge).
WHERE (o.LOCATION = l.LOCATION_CD(+))AND (o.VIOLATION_CD = v.VIOLATION_CD(+))
AND UPPER (l.LOCATION_CD(+)) >= UPPER (‘80000’))AND o.NOMIN_NEW_TIN IS NULL)AND TRIM (’- ,’)