Home » SQL & PL/SQL » Client Tools » TOAD comma question
TOAD comma question [message #649487] Mon, 28 March 2016 14:10 Go to next message
desmond30
Messages: 32
Registered: November 2009
Member
I am using toad 11.6,

I have a view with code something like

select col1,
col2,
col3 from mytable;

There are 100 columns in this view, My goal is to save it somewhere in a .sql file, but the commas should be in the beginning

select col1
,col2
,col3 from mytable;

Is there any option in toad using which I can do this

Re: TOAD comma question [message #649488 is a reply to message #649487] Mon, 28 March 2016 14:55 Go to previous messageGo to next message
Michel Cadot
Messages: 65848
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Those who lives by the GUI die by the GUI.

Re: TOAD comma question [message #649489 is a reply to message #649487] Mon, 28 March 2016 18:42 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8890
Registered: November 2002
Location: California, USA
Senior Member
You could spool the results of a query from user_tables to a file, but what difference does it make where the commas are?
Re: TOAD comma question [message #649491 is a reply to message #649487] Tue, 29 March 2016 00:52 Go to previous message
Littlefoot
Messages: 21439
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Open "Toad Options"; its location might depend on TOAD version. In 12.5, it is in the "View" menu. Then navigate to "Formatter", "List Arrangements", "Commas" - finally, set the format you need.

/forum/fa/13075/0/

Previous Topic: SQL Developer 3 - NLS settings not working
Next Topic: SP2-0111: Cannot close save file "afiedt.buf"
Goto Forum:
  


Current Time: Fri Oct 19 16:48:35 CDT 2018