Re: Editing TOAD's formatting options

taf1_187 <[email protected]>
Newsgroups gmane.comp.db.oracle.toad.free
Message-ID <13113453.1687201323357166281.JavaMail.SYSTEM@alvqcfw02> 
 Message from: taf1_187 

If the formatter options for an IN LIST is settable, I haven't been able to find it.  The 'Oracle Formatter Options' List Arrangement screens need some explanatory text.  For example, the List Arrangement options aren't described anywhere that I've been able to find , so trial and error is the only way to make sense of them, and they still don't make sense.  'Wrapped', 'Stacked on more than..', 'Stacked on overflow or more than', 'Tabular', 'Column adjusted Tabular', 'Wrapped only when no folded Items'.  I'm sure those options make sense to the person or team that wrote the formatter, but they are not obvious to me.  I have been using Toad for years, and I have never found the formatter useful enough to use.  A long IN LIST winds up spread out over pages, one item per line.   I periodicall
 y give it another go but always abandon the effort after being unable to make it do what I want it to do.

_______________________________________

Historical Messages 


Author: taf1_187
Date: Thu Dec 08 07:12:15 PST 2011
If the formatter options for an IN LIST is settable, I haven't been able to find it.  The 'Oracle Formatter Options' List Arrangement screens need some explanatory text.  For example, the List Arrangement options aren't described anywhere that I've been able to find , so trial and error is the only way to make sense of them, and they still don't make sense.  'Wrapped', 'Stacked on more than..', 'Stacked on overflow or more than', 'Tabular', 'Column adjusted Tabular', 'Wrapped only when no folded Items'.  I'm sure those options make sense to the person or team that wrote the formatter, but they are not obvious to me.  I have been using Toad for years, and I have never found the formatter useful enough to use.  A long IN LIST winds up spread out over pages, one item per line.   I periodicall
 y give it another go but always abandon the effort after being unable to make it do what I want it to do.
__

Author: Tim
Date: Thu Nov 03 08:24:31 PDT 2011
Has this been fixed in toad 11?

I can't seem to get the formatter to stack my in list the way I want.


__

Author: Andre Vergison
Date: Sat Feb 06 11:21:17 PST 2010




 

Hello Eric,

Unfortunately a few expression lists have no arrangement options yet. Within a
couple of weeks the Toad beta will feature a reviewed formatter options
interface which will also include options for those lists. That would then meet
your request.

Thanks,

Andre


__

Author: eric.keever_203
Date: Fri Feb 05 10:15:19 PST 2010
 Hi, I have an annoying issue with TOADs formatter tool.&nbsp; When I use the formatter on a query with a large list, I get results like this:

 SELECT *
&nbsp;&nbsp; FROM employee
&nbsp; WHERE employeeID IN ( a,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;b,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;c,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;d,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;e,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;f,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;g,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;h,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;i ); 


 What I&#39;d really like to see for the formatted query&nbsp;is more of a column layout like the following:

 SELECT *
&nbsp;&nbsp; FROM employee
&nbsp; WHERE employeeID IN ( a,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; c,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; d,
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;e,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; g,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; h,
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp; i ); 

Any suggestions as to what I could change in the formatting options menu to get results similar to that?


__
_______________________________________
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.