Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Off Topic: TOAD formatting options

969483Oct 19 2012 — edited Oct 19 2012
Sorry, I know I will probably get shot down in flames for posting this.

I have already sought help via the TOAD community forums via:
http://toadfororacle.com/thread.jspa?threadID=37857&tstart=0

I am using TOAD 10.6.1.3

This is my query:

I've moved to a new job and didn't copy the "FmtPlus.opt" format options file when I left the old job.

On my old TOAD, if I did CTRL + SHIFT + F, the following SQL would look like this:
SELECT DISTINCT fat.application_name
              , fdfv.title
              , fdfcv.descriptive_flexfield_name
           FROM apps.fnd_descriptive_flexs_vl fdfv
              , apps.fnd_descr_flex_contexts_vl fdfcv
              , applsys.fnd_application_tl fat
          WHERE fdfv.application_id = fdfcv.application_id
            AND fdfv.descriptive_flexfield_name = fdfcv.descriptive_flexfield_name
            AND fdfv.application_id = fat.application_id
            AND fat.application_name = 'Receivables'
            AND fdfv.title = 'Address';
But on the new install, it comes out as:
SELECT DISTINCT fat.application_name
              , fdfv.title
              , fdfcv.descriptive_flexfield_name
  FROM apps.fnd_descriptive_flexs_vl fdfv
     , apps.fnd_descr_flex_contexts_vl fdfcv
     , applsys.fnd_application_tl fat
 WHERE fdfv.application_id = fdfcv.application_id
   AND fdfv.descriptive_flexfield_name = fdfcv.descriptive_flexfield_name
   AND fdfv.application_id = fat.application_id
   AND fat.application_name = 'Receivables'
   AND fdfv.title = 'Address';
I've changed lots of settings in the formatting options in TOAD, but can't work out how to get the SQL to align as per my old version.

Any advice on how to get the formatter to generate output like in the first example would be much appreciated.

Thanks
This post has been answered by Kim Berg Hansen on Oct 19 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 16 2012
Added on Oct 19 2012
2 comments
1,811 views