Home » SQL & PL/SQL » Client Tools » TOAD - Query output with column headers (TOAD version 10.0.0.041)
TOAD - Query output with column headers [message #456034] Fri, 14 May 2010 04:00 Go to next message
Ravin_C
Messages: 38
Registered: February 2008
Location: United Kingdom
Member
Guys,

Still I can't figure out how to configure the query editor to copy the column headers with the query results on to the clipboard?

Please help!

[Updated on: Fri, 14 May 2010 04:01]

Report message to a moderator

Re: TOAD - Query output with column headers [message #456039 is a reply to message #456034] Fri, 14 May 2010 04:39 Go to previous messageGo to next message
Littlefoot
Messages: 21332
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Right-click query output ("Data Grid" tab, probably). Choose "Export dataset ...". Choose desired export format (for example, "HTML Table" is nice for pasting into MS Word or MS Outlook). Set other options (if necessary). Click "OK".
icon7.gif  Re: TOAD - Query output with column headers [message #456041 is a reply to message #456039] Fri, 14 May 2010 04:45 Go to previous messageGo to next message
Ravin_C
Messages: 38
Registered: February 2008
Location: United Kingdom
Member
Thank you, you are a star!
Re: TOAD - Query output with column headers [message #530052 is a reply to message #456041] Fri, 04 November 2011 06:40 Go to previous messageGo to next message
Ravin_C
Messages: 38
Registered: February 2008
Location: United Kingdom
Member
Hi,

Everything was fine suddenly its now copying just the HTML code to the clipboard instead!!! Any ideas why please?
Re: TOAD - Query output with column headers [message #530053 is a reply to message #530052] Fri, 04 November 2011 06:44 Go to previous messageGo to next message
Littlefoot
Messages: 21332
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Works fine for me.

What did you suddenly change?

[EDIT]

On MS Windows 7, when pasting HTML table output into Outlook mail message (using the right mouse click), I have three options:
- keep source formatting (K)
- merge formatting (M)
- keep text only (T)

The third option pastes HTML code.

Did you do something like that?

[Updated on: Fri, 04 November 2011 06:47]

Report message to a moderator

Re: TOAD - Query output with column headers [message #530054 is a reply to message #530053] Fri, 04 November 2011 07:06 Go to previous messageGo to next message
Ravin_C
Messages: 38
Registered: February 2008
Location: United Kingdom
Member
Ah, recently i was upgraded to Windows 7, i can see the PASTE options and its on (T), its not changing!!
Re: TOAD - Query output with column headers [message #530055 is a reply to message #530054] Fri, 04 November 2011 07:07 Go to previous messageGo to next message
Littlefoot
Messages: 21332
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So ... is the problem solved now?
Re: TOAD - Query output with column headers [message #530056 is a reply to message #530055] Fri, 04 November 2011 07:08 Go to previous messageGo to next message
Ravin_C
Messages: 38
Registered: February 2008
Location: United Kingdom
Member
nope can't do the option changed!!!
Re: TOAD - Query output with column headers [message #530057 is a reply to message #530056] Fri, 04 November 2011 07:11 Go to previous messageGo to next message
Littlefoot
Messages: 21332
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
That's no more an Oracle problem, but your operating system's one. Does this help?
Re: TOAD - Query output with column headers [message #530059 is a reply to message #530057] Fri, 04 November 2011 07:21 Go to previous messageGo to next message
Ravin_C
Messages: 38
Registered: February 2008
Location: United Kingdom
Member
did try as per instructions still no luck LOL!!!
Re: TOAD - Query output with column headers [message #530060 is a reply to message #530059] Fri, 04 November 2011 07:25 Go to previous messageGo to next message
Littlefoot
Messages: 21332
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It seems that you'll have to learn Windows 7 a little bit better than now.

Though, what's wrong with right-click and choosing paste option you like the most?

[Updated on: Fri, 04 November 2011 07:25]

Report message to a moderator

Re: TOAD - Query output with column headers [message #530061 is a reply to message #530060] Fri, 04 November 2011 07:31 Go to previous messageGo to next message
Ravin_C
Messages: 38
Registered: February 2008
Location: United Kingdom
Member
There is no option to change on right click still showin the (T) option even though i have chaged it on Advanced option as per the Geek's advise!!
Re: TOAD - Query output with column headers [message #530062 is a reply to message #530061] Fri, 04 November 2011 07:42 Go to previous messageGo to next message
Littlefoot
Messages: 21332
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is what I have (MS Office 2010):

/forum/fa/9535/0/

No further ideas, sorry.
Re: TOAD - Query output with column headers [message #530063 is a reply to message #530062] Fri, 04 November 2011 07:46 Go to previous messageGo to next message
Ravin_C
Messages: 38
Registered: February 2008
Location: United Kingdom
Member
aaaahhh!! mine only has the 'A' option, donno why!! anyway thanks for your help, greatly appreciated!!
Re: TOAD - Query output with column headers [message #530064 is a reply to message #530063] Fri, 04 November 2011 07:49 Go to previous messageGo to next message
Ravin_C
Messages: 38
Registered: February 2008
Location: United Kingdom
Member
how did you get the screenshot anyway, any tool used?
Re: TOAD - Query output with column headers [message #530065 is a reply to message #530064] Fri, 04 November 2011 07:49 Go to previous messageGo to next message
Littlefoot
Messages: 21332
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No; standard "Print screen", cut with Paint.
Re: TOAD - Query output with column headers [message #530066 is a reply to message #530065] Fri, 04 November 2011 07:52 Go to previous messageGo to next message
Ravin_C
Messages: 38
Registered: February 2008
Location: United Kingdom
Member
ok,cool
Re: TOAD - Query output with column headers [message #530184 is a reply to message #530066] Sun, 06 November 2011 05:01 Go to previous messageGo to next message
Flyby
Messages: 182
Registered: March 2011
Location: Belgium
Senior Member
To copy with headers: select all (grid), CTRL+INSERT (Toad), paste
Re: TOAD - Query output with column headers [message #530218 is a reply to message #530184] Mon, 07 November 2011 04:43 Go to previous message
Littlefoot
Messages: 21332
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Right! It seems to be working, although all formatting is lost (the result is pasted as "text only" - that would be the "A" option on my screenshot in a message #530062). But I guess that it is far better than having HTML code, isn't it?
Previous Topic: db link creation
Next Topic: TOAD error ORA-00900 Procedural Software Installation
Goto Forum:
  


Current Time: Sat Jan 20 04:29:01 CST 2018

Total time taken to generate the page: 0.02226 seconds