Toad World® Forums

Too many brackets when building queries visually!


#1

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 (’- ,’)


#2

That’s a point:) We will take a look at extraneous parentheses for TDA 3.0. I entered CR 78021 for this.

Debbie


#3

Appreciated