Toad World® Forums

Toad 12.0.0.61 Formatter


#1

Hi,

I was wondering if anyone can help me with the formatter specifically using distinct in a select statement.

I have pretty much everything else coming out nicely using the formatter except when using distinct.

So as an example here is an example statement.

select

distinct

column1,

column2

from

dual

Using the formatter this comes out as:

select

distinct column1,

column2

from

dual

However I would like to appear as :

select

distinct

column1,

column2

from

dual

I believe I have tried every possible option in the formatter but I can’t seem to affect how it handles this distinct option.

Any help would be greatly appreciated.

Cheers,

George Woods.


#2

What is the practical meaning of arranging the DISTINCT keyword this way? DISTINCT is just an attribute of the select list (= column1, column2). If we put it left then it would rather look like a clause.


#3

Hi Andre,

The actual positioning of the DISTINCT keyword is less important to me in that it coudl be after the select. Thats not an issue. I just don’t like where the selected columns are positioned.

So for example I have no issue with below:

select distinct

column1,

column2

from

dual

However the formatter would still position the columns to the right of the distinct attribute like below:

select distinct column1,

column2

from

dual

I would prefer it to create a new line for the columns rather than starting way off to the right like above.


#4

Your suggestion…

select distinct
column1,
column2
from
dual

…makes sense. I’ll see what I can do.

Thanks,

Andre


#5

Hi Andre,

Did you ever manage to get this to work?


#6

Hello,

Andre has this fixed for 12.1. We are working on a
possible work-around now. We will let you know.

Thanks,

Brad

From: gwoods [mailto:bounce-gwoods@toadworld.com]

Sent: Tuesday, August 13, 2013 12:17 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Toad 12.0.0.61 Formatter

RE: Toad 12.0.0.61 Formatter

Reply by gwoods

Hi Andre,

Did you ever manage to get this to work?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.