Home » Other » 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: 21823
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".

Report message to a moderator

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!

Report message to a moderator

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?

Report message to a moderator

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: 21823
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!!

Report message to a moderator

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: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
So ... is the problem solved now?

Report message to a moderator

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!!!

Report message to a moderator

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: 21823
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?

Report message to a moderator

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!!!

Report message to a moderator

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: 21823
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!!

Report message to a moderator

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: 21823
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.

Report message to a moderator

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!!

Report message to a moderator

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?

Report message to a moderator

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: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No; standard "Print screen", cut with Paint.

Report message to a moderator

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

Report message to a moderator

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: 188
Registered: March 2011
Location: Belgium
Senior Member
To copy with headers: select all (grid), CTRL+INSERT (Toad), paste

Report message to a moderator

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: 21823
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?

Report message to a moderator

Previous Topic: db link creation
Next Topic: TOAD error ORA-00900 Procedural Software Installation
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Feb 06 13:09:19 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.