Toad World® Forums

Materialized View formatting


shouldn’t Mat Views format like views?

And, shouldn’t the select statement within both format the same as a select statement?

Just sayin…


p.s. while we’re at it, can we get a “keywords Left Aligned except Top Line”? It’d be nice to have the the keywords line up and be indented after the first keyword.


Hi Jet,

In fact the “Hanging indent” option should work like you expect for this one, but it was broken and we didn’t notice that. Thanks for pointing this out. I have raise a CR for the formatter team to fix it.



I forgot to mention: another CR has been raised too for the issue formatting Materialized View.


Hi, vliu!

“Hanging indent” option still does not work.

Formatter options v.5.157
Formatter engine v.5.160