Editor formatting

Toad for Oracle
1

I just upgraded to TOAD version 12.9.0.71 and am having a problem. Is there a setting to have the “AS” clauses and file alias’s one space after the column / file instead of aligned to the right? I had it this way on 12.8 but can’t remember how that was set.

The formatter is currently giving me this:

I would like to have this:

I have tried changing many of the options but to no avail. Anything you can tell me would be appreciated.

Thanks,

Gregg Hannibal

Centric Group, LLC

1260 Andes Blvd.

St. Louis, MO 63132

314.214.2821

ghannibal@centricgroup.com

2

Hello Gregg,

The examples you want to show are missing in the post …

3

Sorry. Apparently I had screen images it didn’t like. Here is the text:

Currently giving me this:

=======================

SELECT kpc.record_status “Sts”

  ,kpc.customer_number || '-' || kpc.customer_suffix "Legacy"

  ,hca.account_number                                "Oracle"

  ,kib.batch_number                                  "Batch"

  ,kpc.order_type                                    "OTyp"

  ,hca.sales_channel_code                            "Channel"

  ,hca.account_name                                  "Name"

  ,kpc.processing_control_number

      "Processing Control Number"

  ,kpc.creation_date                                 "Creation"

  ,kpc.error_message                                 "Error Message"

  ,kpc.request_id                                    "Request"

  ,kpc.last_update_date                              "Last Update"

FROM xxcnc.xxcnc_kcn_proc_control kpc

,hz_cust_accounts_all                hca

,xxcnc.xxcnc_kcn_oe_ifac_batch_stg   kib

=================

I would like to have this:

=================

SELECT kpc.record_status “Sts”

  ,kpc.customer_number || '-' || kpc.customer_suffix "Legacy"

  ,hca.account_number "Oracle"

  ,kib.batch_number "Batch"

  ,kpc.order_type "OTyp"

  ,hca.sales_channel_code "Channel"

  ,hca.account_name "Name"

  ,kpc.processing_control_number "Processing Control Number"

  ,kpc.creation_date "Creation"

  ,kpc.error_message “Error Message"

  ,kpc.request_id "Request"

  ,kpc.last_update_date "Last Update"

FROM xxcnc.xxcnc_kcn_proc_control kpc

,hz_cust_accounts_all hca

,xxcnc.xxcnc_kcn_oe_ifac_batch_stg kib

=================

Hopefully this gets through this time. Thanks for your reply!!! Gregg

4

Okay :slight_smile: Yeah, the alignment of columns and table references was included a little while ago in 12.9, unfortunately without the possibility to turn it off.

We’re in the process of making a new formatter component which will make it in 12.9 by next week the latest. It will have two checkboxes in the DML tab which allow you to trigger this new feature, separately for columns and table references.

These options will be initially turned off, preserving the 12.8 behavior. You can enable them whenever you want it.

Thanks,
Andre

5

Andre,

THANKS for your help!!!

Gregg