Re: RE: formatting copy/paste query results

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

Hi, 

thanks for the response.&nbsp; 

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

 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 

_______________________________________

Historical Messages 


Author: Christine Edwards
Date: Mon Oct 03 09:07:52 PDT 2011
Hi, 

thanks for the response.&nbsp; 

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

 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
__

Author: Jeff Smith
Date: Mon Oct 03 08:07:40 PDT 2011




 

Ctrl&#43;Insert will copy selected rows WITH headers

Ctrl&#43;C will copy selected rows WITHOUT headers


__

Author: Christine Edwards
Date: Mon Oct 03 08:07:40 PDT 2011

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&#39;t under the header.&nbsp; 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
__
_______________________________________
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.