formatting copy/paste query results

Toad for Oracle & DevOps Toolkit
1

Hi all,

New to TOAD so I am having a few problems…

I can do the ctrl/insert to copy query results but the resulting data isn’t under the header. Is there a way to copy/paste so you can see the header and the data for that field under that header?

Thanks in advance for your help,
christine

2

Ctrl+Insert will copy selected rows WITH headers

Ctrl+C will copy selected rows WITHOUT headers

3

CLOSING_DATE STORE_NO DIV_NO NEW_BUSINESS_DATE TIMESTAMP STORE_CLOSE_FLG CHK_REG_CLOSE_FLG AGE_BKRM_FLG PURGE_BKRM_FLG PURGE_CSH_REG_FLG ROLL_BUSINESS_DT_FLG SALES_AUDIT_PROC_FLG

9/13/2011 1101 0 9/14/2011 9/28/2011 8:19:21 PM Y N N N N N N

Is there a way to get the data to show up under the corresponding header?

Thanks,
christine

Hi,

thanks for the response.

I want the headers, but would like the data for a column under the actual header. When I copy with headers the paste looks like this

**

4

Use the Export Data widget – use ‘Fixed Field Spacing’ to
clipboard for selected rows option.

5

when i ctrl+c and ctrl+v the headers pase . ı dont want to copy heades, only selected.

6

ctrl+insert

On Mon, Aug 7, 2017 at 9:14 AM, ekremnn bounce-ekremnn@toadworld.com wrote:

RE: formatting copy/paste query results

Reply by ekremnn
when i ctrl+c and ctrl+v the headers pase . ı dont want to copy heades, only selected.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle Forum notifications altogether.

Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.

--
Gene L. Bradley Jr.

Systems Analyst

Office of Information Technology

Jackson State University

1400 J R Lynch Street

P.O. Box 17750

Jackson, MS 39217

ph 601.979.1042

fax 601.371.9146

email gbradley@jsums.edu

*In God we trust; all others bring data. * ~W.E. Deming

CONFIDENTIALITY STATEMENT

This electronic transmission is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by telephone (601) 979-1042. Thank you.