formatter setting for alignments

Toad for Oracle
1

Please tell me how can I get the formatter to take this:

  AND D.EFFDT = (SELECT MAX ( D_ED.EFFDT )

                   FROM PS_CF_ATTRIB_TBL D_ED

                  WHERE D.SETID = D_ED.SETID

                    AND D.CHARTFIELD_VALUE = D_ED.CHARTFIELD_VALUE

                    AND D.CF_ATTRIBUTE = 'STATEFUND'

                    AND D_ED.EFFDT <= SYSDATE)

and format as this:

  AND D.EFFDT = (SELECT MAX ( D_ED.EFFDT )

                   FROM PS_CF_ATTRIB_TBL D_ED

                  WHERE D.SETID            = D_ED.SETID

                    AND D.CHARTFIELD_VALUE = D_ED.CHARTFIELD_VALUE

                    AND D.CF_ATTRIBUTE     = 'STATEFUND'

                    AND D_ED.EFFDT         <= SYSDATE )

                

                                                                                          ^  I want these to line up

I’ve been setting “Alignments” at either fixed or dynamic with various offset values and ‘space between’ values but it doesn’t seem to do anything.

2

This is an open request. See http://www.toadworld.com/products/toad-for-oracle/f/10/t/30967 for details.

Thanks,
Andre