It would be nice if the SQL text window (or even other spots) had a CopyToClipboard option. I often copy/paste to send to another developer and its somewhat annoying to always roundtrip through notepad to remove the html.
Can you give us an example of what you paste it into, and what it looks like when you do?
I usually grab it and paste it into outlook. It looks horrible as below (or see image)
SELECT
/*+ cardinality (gtt_sisd 1) */
VDI.*,
VSI.*,
VIIF.*,
(
SELECT LISTAGG(TCCXA.AGMT_TYPE||'-'||TCCXA.AGMT_NUMBER, ',') WITHIN
GROUP (
ORDER BY TCCXA.AGMT_TYPE||'-'||TCCXA.AGMT_NUMBER)
FROM T_CC_XREF_AGMT TCCXA
WHERE TCCXA.CC_XREF_ID = VSI.S_CC_XREF_ID
AND TCCXA.PRT_BA_ID = VSI.S_PRT_BA_ID
GROUP BY TCCXA.CC_XREF_ID
)
S_AGMT_LIST
FROM GTT_SEARCH_INV_STMT_DTL GTT_SISID
JOIN V_INVOICE_IBD_FSP VIIF
ON GTT_SISID.INVOICE_ID = VIIF.I_INVOICE_ID
JOIN V_STATEMENT_IBD VSI
ON GTT_SISID.STATEMENT_ID = VSI.S_STATEMENT_ID
JOIN V_DETAIL_IBD VDI
ON GTT_SISID.STATEMENT_ID = VDI.D_STATEMENT_ID
Image incase your email server eats the html or something
Trying to revive this request... 4 years later and it still drives me nuts.
