# Formatter issue

**URL:** <https://forums.toadworld.com/t/formatter-issue/32365>\
**Category:** Toad for Oracle - Beta\
**Created:** [January 21, 2015, 5:58am UTC](https://forums.toadworld.com/t/formatter-issue/32365 "2015-01-21T05:58:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![kornelis.abe](https://avatars.discourse-cdn.com/v4/letter/k/59ef9b/32.png) [@kornelis.abe](https://forums.toadworld.com/u/kornelis.abe)\
**Post date:** [January 21, 2015, 5:58am UTC](https://forums.toadworld.com/t/formatter-issue/32365/1 "2015-01-21T05:58:36Z")

</div>

Hello,

I formatted one of my triggers and got misalignment on the trigger’s when clause predicates:

create or replace trigger iib\_krg.sfsytextlang\_class234\_raiud  
after insert or update or delete  
on ehda.sfsytextlang (when cmptname between ‘CLASS1’ and ‘CLASS4’  
and cmpttype = ‘CVA’  
and langcode = ‘ENG’)  
for each row  
declare  
etc.

Would it be feasible to modify the formatter’s behaviour, so that the predicates in the when clause align properly?  
Preferentially, I would like to see the when clause starting on a line of its own, then the usual formatting rules can be applied to its component predicates.  
Otherwise, the when clause can be left on the same line as the on clause, but then the predicates on the subsequent lines should move to the right to align with the first predicate in the when clause.

any comments or suggestions appreciated.

# Abe Kornelis

---

<div class="post-metadata">

**Author:** ![kornelis.abe](https://avatars.discourse-cdn.com/v4/letter/k/59ef9b/32.png) [@kornelis.abe](https://forums.toadworld.com/u/kornelis.abe)\
**Post date:** [January 21, 2015, 6:27am UTC](https://forums.toadworld.com/t/formatter-issue/32365/2 "2015-01-21T06:27:39Z")

</div>

To all,

my apologies. I had missed the syntax error that was reported by the formatter.

Now that the syntax is ok, formatter behaves fine.

Sorry to have bothered you.

Abe

===