Toad World® Forums

formatter setting for alignments

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.

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

Thanks,
Andre