Where to find it in the customizing formatter section

Toad for Oracle & DevOps Toolkit
1

Hi Folks:

I’m trying to figure out how to do the following.

I have my code formatter currently set to format like below:

CREATE OR REPLACE TRIGGER necropsies_trg
BEFORE INSERT
ON necropsies
REFERENCING NEW AS new OLD AS old

I am trying to get the formatter to place the BEFORE INSERT ON necropsies statement on one line like like the following:

CREATE OR REPLACE TRIGGER necropsies_trg
BEFORE INSERT ON necropsies
REFERENCING NEW AS new OLD AS old
FOR EACH ROW

Any idea what section in the Formatter section I would tweak to do that? I’ve spent an hour trying different things but nothing has worked so far.

Thanks,

Matthew

2

Hi Matthew,

Currently there is no option to change the layout of trigger timing and events. If we do a change then it could be one of the following things:

1/ Either change it to keep the BEFORE on the same line,
2/ Add an option (checkbox?) to choose between the two formats.

The format that you request seems to be popular indeed. Are there other readers out there wishing to share their preference?

Thanks,
Andre