shell - sql中的错误加上执行大字符串头

Question

执行此脚本后，我在 sql plus 中收到此错误。这是具有> 150列的文件的标题。我尝试了其他选项，例如

rtrim (xmlagg (xmlelement (e, x || '|')).extract ('//text()'), '|')  

但没有运气。

SP2-0027：输入太长（> 2499 个字符）- 忽略行

abc.sh
    sqlplus -s /nolog << EOF
    connect abc/pwd@orcl;
    whenever sqlerror exit sql.sqlcode;
    set wrap ON
    set trimout ON
    set trimspool on
    set serveroutput on
    set pagesize 0
    set long 20000000
    set longchunksize 20000000
    set linesize 4000
    spool abc.sql
    select TO_CLOB('SCSTSUMID|IMAILSUMID|FTOMERSUMKY|FGHERNAME|EILSUMADDR|FSTSUMNM|MIHZDLESUMNM|LZSTSUMNM|PRIMSUMADDR|SECSUMADDR|CITY|STATE|POSTALSUMCD|ISOSUMCODE|UNIVSUMDCOM|UNIVSUMDCOMSUMALWSUM13T17|UNIVSUMDCOMSUMALWSUMCAN|UNIVSUMDCOMSUMALWSUMCANSUM13T17|UNIVSUMPRTR|UNIVSUMPRTRSUMALWSUM13T17|UNIVSUMPRTRSUMALWSUMCAN|UNIVSUMPRTRSUMALWSUMCANSUM13T17|UNIVSUMSHOP|UNIVSUMDCOMSUMALWSUMUKDB|UNIVSUMLIVESUMCOMBINE|UNIVSUMLIVESUMDRAFT|UNIVSUMLIVESUMKICKOFF|UNIVSUMLIVESUMISGUKSUMUKDB|UNIVSUMLIVESUMISGUKSUMNOSUMUKDB|UNIVSUMLIVESUMISGMX|UNIVSUMLIVESUMPROBOWL|UNIVSUMLIVESUMSUPERBOWL|UNIVSUMDCOMSUMRECURR|UNIVSUMDCOMSUMRECURRSUM13T17|UNIVSUMDCOMSUMALWSUMHOLDOUT|UNIVSUMDCOMSUMRCRSUMALWSUMHLDOUT|AGE|GENDER|BIRTHSUMDT|CUSTSUMRECENCYSUMDT|HISPANICSUMFLG|FAVSUMTEAMSUMCD|ACTIVESUM0SUM3MSUMFLG|ACTIVESUM4SUM6MSUMFLG|ACTIVESUM7SUM9MSUMFLG|ACTIVESUM10SUM12MSUMFLG|ACTIVESUM0SUM12MSUMFLG|ACTIVESUM13SUM15MSUMFLG|ACTIVESUM16SUM18MSUMFLG|OUTSUMMKTSUMFAVSUMTEAMSUMFLG|ORIGSUMSRC|ORIGSUMSRCSUMDT|ORIGSUMSRCSUMBU|BUSUMCLUBSSUMFLG|BUSUMDCOMSUMFLG|BUSUMLIVESUMEVENTSUMFLG|BUSUMPRTRSUMFLG|BUSUMSHOPSUMFLG|BUSUMINTLSUMFLG|BUSUMOTHRSUMFLG|BUSUMMKTGSUMFLG|CROSSOVERSUMNFLSUMCLUBSSUMFLG|LSTSUMFANTASYSUMSSN|LSTSUMSUBSUMPROD|LSTSUMSUBSUMPRODSUMSSN|LSTSUMGPDSUMSUBSUMSSN|LSTSUMGPDSUMFTSUMSSN|LSTSUMGPISUMSUBSUMSSN|LSTSUMGPISUMFTSUMSSN|LSTSUMGPISUMSUBSUMSSNSUMSSN|LSTSUMGPISUMSUBSUMSSNPLSSUMSSN|LSTSUMGPISUMSUBSUMWKLYSUMSSN|LSTSUMGPISUMSUBSUMFYTSUMSSN|LSTSUMMINIGMSUMSSN|LSTSUMMINIGMSUMSSNSUMREGSUMDT|LSTSUMTNFCHSUMSSN|LSTSUMTNFCHSUMSSNSUMREGSUMDT|LSTSUMDRAFTSUMFMPSUMSSN|LSTSUMKICKOFFSUMFMPSUMSSN|LSTSUMSBSUMFMPSUMSSN|LSTSUMPBSUMSTHSUMSSN|LSTSUMPBSUMSTBSUMSSN|SHOPSUMLSTSUMPURCHSUMDT|EMSUMLSTSUMOPENSUMDT|EMSUMLSTSUMCLICKSUMDT|WEBSUMLSTSUMVSTSUMDT|APPSUMLSTSUMVSTSUMDT|FANTASYSUMLSTSUMVSTSUMDT|LSTSUMCLUBSSUMSTHSUMSSN|LSTSUMCLUBSSUMSTBSUMSSN|DTVSUMSUNDAYSUMTICKETSUMFLG|DTVSUMSUNDAYSUMTICKETSUMACTIVESUMFLG|DTVSUMTVSUMFLG|DTVSUMTVSUMACTIVESUMFLG|DTVSUMCOMMERICALSUMFLG|DTVSUMCOMMERICALSUMACTIVESUMFLG|PARENTSUMFLG|TRANSACTIONALSUMVALUE|TSPSUMHHSUMINCOME|NICHE|GPDSUMGPIROWSUMCOUNTRY|GPESUMCOUNTRY|EMSUMNFLNSUMWEEKLYSUMFLG|EMSUMNFLNSUMWEEKLYSUMLSTSUMACTIVTYSUMDT|EMSUMNFLNSUMFLG|EMSUMNFLNSUMLSTSUMACTIVTYSUMDT|EMSUMGMFBSUMFLG|EMSUMGMFBSUMLSTSUMACTIVTYSUMDT|EMSUMTNFSUMFLG|EMSUMTNFSUMLSTSUMACTIVTYSUMDT|EMSUMGDPSUMFLG|EMSUMGDPSUMLSTSUMACTIVITYSUMDT|EMSUMFANTSUMRPTSUMFLG|EMSUMFANTSUMRPTSUMLSTSUMACTIVITYSUMDT|EMSUMFANTSUMCORESUMFLG|EMSUMFANTSUMCORESUMLSTSUMACTIVITYSUMDT|LSTSUMFANTSUMLMSUMSSN|LSTSUMFANTSUMUESUMSSN|LSTSUMFANTSUMCUSTOMSUMSSN|LSTSUMFANTSUMMANAGEDSUMSSN|SHOPSUMYOUTHSUMGIRLSSUMFLG|SHOPSUMYOUTHSUMFLG|PARENTSUMACQUISITIONSUMFLG|YOUTHSUMACQUISITIONSUMFLG|CHILDRENSUMFLG|LSTSUMPTPSUMSSN|NEWSUMTOSUMFCMSUM0SUM3MSUMFLG|FOOTBALLSUMAFFINITYSUMFLG|GPDSUMPAGEVISITSUMFLG|GPDSUMPAGEVISITSUMLSTSUMACTIVITYSUMDT|FANTSUMPAGEVISITSUMFLG|FANTSUMPAGEVISITSUMLSTSUMACTIVITYSUMDT|NFLNSUMAAMSUMSEGMENTSUMFLG|CURRSUMSSNSUMVIDEOSUMVIEWSSUMFLG|GPDSUMSTATUS|GPISUMSTATUS|GPESUMSTATUS|MXSUMOPTSUMINSUMFLAG|DESUMOPTSUMINSUMFLAG|CASUMOPTSUMINSUMFLAG|UKSUMOPTSUMINSUMFLAG|CLUSTERSUMN|CLUSTERSUMPNL|LSTSUMPBSUMFMPSUMSSN|EXTRACTSUMSEQ|HASDKSUMPROBS|SBSPNDSUMPROBS|DRAFTEDSUMFLG|EMAILSUMTIER|TSPSUMZIPSUMCD|TSPSUMSTATESUMABBREVIATION|TSPSUMADDRSUMTYPE|TSPSUMADVSUMHMSUMOWNR|TSPSUMADVSUMHHSUMSIZE|TSPSUMADVSUMHHSUMSIZESUMINDICATOR|TSPSUMADVSUMHHSUMMARITALSUMSTATUS|TSPSUMADVSUMHHSUMMARITALSUMSTATSUMIND|TSPSUMADVSUMDWELLINGSUMTYPE|TSPSUMADVSUMDWELLINGSUMTYPESUMIND|TSPSUMADVSUMTARGETSUMINCOMESUM2|TSPSUMADVSUMTARGETSUMINCOMESUMINDSUM2|TSPSUMADVSUMHHSUMEDUCATION|TSPSUMADVSUMHHSUMEDUCATIONSUMINDICATOR|TSPSUMAGESUMUNK|TSPSUMAGESUM75SUMPLUS|TSPSUMAGESUM65SUM74|TSPSUMAGESUM55SUM64|TSPSUMAGESUM45SUM54|TSPSUMAGESUM35SUM44|TSPSUMAGESUM25SUM34|TSPSUMAGESUM18SUM24|TSPSUMCHILDRENSUMAGESUM0SUM2|TSPSUMCHILDRENSUMAGESUM3SUM5|TSPSUMCHILDRENSUMAGESUM6SUM10|TSPSUMCHILDRENSUMAGESUM11SUM15|TSPSUMCHILDRENSUMAGESUM16SUM17|TSPSUMHHSUMTYPESUMFAMILYSUMCOMP|TSPSUMOCCUPATION|TSPSUMGENDERSUMPRSN|TSPSUMETHNICSUMGRP|TSPSUMETHNICSUMGRPSUMPRSN|TSPSUMLANGUAGESUMPRSN|TSPSUMTARGETSUMVALUESCORESUM2|TSPSUMCCSUMAMERSUMEXPRESS|TSPSUMCCSUMANYSUMCC|TSPSUMCCSUMBANKSUMCARD|TSPSUMCCSUMCATALOGSUMSHOWROOM|TSPSUMCCSUMCOMPUTERSUMELECTRONIC|TSPSUMCCSUMDEBITSUMCARD|TSPSUMCCSUMFINANCESUMCOSUMCARD|TSPSUMCCSUMFURNITURE|TSPSUMCCSUMGROCERY|TSPSUMCCSUMHMSUMIMPROVEMENT|TSPSUMCCSUMHMSUMOFFICESUMSUPPLY|TSPSUMCCSUMLOWSUMENDSUMDEPTSUMSTORE|TSPSUMCCSUMMAINSUMSTREETSUMRETAIL|TSPSUMCCSUMMASTERCARD|TSPSUMCCSUMMBRSHPSUMWHS|TSPSUMCCSUMMISC|TSPSUMCCSUMOILSUMGASSUMCARD|TSPSUMCCSUMSPECIALTYSUMAPPAREL|TSPSUMCCSUMSPORTINGSUMGOODS|TSPSUMCCSUMSTANDARDSUMRETAIL|TSPSUMCCSUMSTANDARDSUMSPECIALTYSUMCARD|TSPSUMCCSUMTRAVELSUMENTERTAINMENT|TSPSUMCCSUMTVSUMMAILSUMORDER|')||'TSPSUMCCSUMUPSCALESUMRETAIL|TSPSUMCCSUMUPSCALESUMSPECSUMRETAIL|TSPSUMCCSUMVISA|TSPSUMMTSUMFOOTBALLSUMENTHUSIASTS|TSPSUMMTSUMSMARTSUMPHONESUMUSER|TSPSUMMTSUMHIGHENDSUMAMSUMRANKSUMTM2|FANTSUMOPPSUMTEAMSUMNMSUMTM2|FANTSUMOPPSUMTEAMSUMRANKSUMTM2|FANTSUMLEAGUESUMIDSUMTM3|FANTSUMTEAMSUMIDSUMTM3|FANTSUMTEAMSUMNMSUMTM3|FANTSUMTEAMSUMRANKSUMTM3|FANTSUMOPPSUMTEAMSUMNMSUMTM3|FANTSUMOPPSUMTEAMSUMRANKSUMTM3|JEBBITSUMATTRIB13SUMFLG|JEBBITSUMATTRIB12SUMFANTSUMFLG|JEBBITSUMATTRIB11SUMKIDSSUMFLG|MSSUMONSUMLOCATION|MSSUMBARCLAY|BARCLAYSUMPASSIONSUMJETSETSUMIND|BARCLAYSUMPASSIONSUMELECSUMIND|BARCLAYSUMPASSIONSUMEGOERSUMIND|LSTSUMGPDSUMSTREAMSUMDT|GPDSUMMINSUMWATCHEDSUMCURRSUMSSN|GPDSUMMINSUMWATCHEDSUMPREV1SUMSSN|GPDSUMMINSUMWATCHEDSUMPREV2SUMSSN|FAVSUMTEAMSUMCDSUMIMPLIED|FAVSUMTEAMSUMCDSUMSUPPLIED|EXTRACTSUMDT' x from dual ;
    spool off;
    exit;
    EOF

任何建议将不胜感激。

标签： shellunixoracle12cclob

Answer 1

您在 SQL*Plus 中达到了 SQL 行长度的物理限制。有关如何解决的更多信息，请参阅此帖子：https ://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:4789399600346029472

基本上，您将不得不用换行符分解输入文本并连接各个行，如下所示：

abc.sh
    sqlplus -s /nolog << EOF
    connect abc/pwd@orcl;
    whenever sqlerror exit sql.sqlcode;
    set wrap ON
    set trimout ON
    set trimspool on
    set serveroutput on
    set pagesize 0
    set long 20000000
    set longchunksize 20000000
    set linesize 4000
    spool abc.sql
    select TO_CLOB('SCSTSUMID|IMAILSUMID|FTOMERSUMKY|FGHERNAME|EILSUMADDR|FSTSUMNM|MIHZDLESUMNM|LZSTSUMNM|PRIMSUMADDR|SECSUMADDR|CITY|STATE|POSTALSUMCD|ISOSUMCODE|UNIVSUMDCOM|UNIVSUMDCOMSUMALWSUM13T17|UNIVSUMDCOMSUMALWSUMCAN|UNIVSUMDCOMSUMALWSUMCANSUM13T17|UNIVSUMPRTR|UNIVSUMPRTRSUMALWSUM13T17|UNIVSUMPRTRSUMALWSUMCAN|UNIVSUMPRTRSUMALWSUMCANSUM13T17|UNIVSUMSHOP|UNIVSUMDCOMSUMALWSUMUKDB|UNIVSUMLIVESUMCOMBINE|UNIVSUMLIVESUMDRAFT|UNIVSUMLIVESUMKICKOFF|UNIVSUMLIVESUMISGUKSUMUKDB|'
    || 'UNIVSUMLIVESUMISGUKSUMNOSUMUKDB|UNIVSUMLIVESUMISGMX|UNIVSUMLIVESUMPROBOWL|UNIVSUMLIVESUMSUPERBOWL|UNIVSUMDCOMSUMRECURR|UNIVSUMDCOMSUMRECURRSUM13T17|UNIVSUMDCOMSUMALWSUMHOLDOUT|UNIVSUMDCOMSUMRCRSUMALWSUMHLDOUT|AGE|GENDER|BIRTHSUMDT|CUSTSUMRECENCYSUMDT|HISPANICSUMFLG|FAVSUMTEAMSUMCD|ACTIVESUM0SUM3MSUMFLG|ACTIVESUM4SUM6MSUMFLG|ACTIVESUM7SUM9MSUMFLG|ACTIVESUM10SUM12MSUMFLG|ACTIVESUM0SUM12MSUMFLG|ACTIVESUM13SUM15MSUMFLG|ACTIVESUM16SUM18MSUMFLG|OUTSUMMKTSUMFAVSUMTEAMSUMFLG|ORIGSUMSRC|ORIGSUMSRCSUMDT|'
    || 'ORIGSUMSRCSUMBU|BUSUMCLUBSSUMFLG|BUSUMDCOMSUMFLG|BUSUMLIVESUMEVENTSUMFLG|BUSUMPRTRSUMFLG|BUSUMSHOPSUMFLG|BUSUMINTLSUMFLG|BUSUMOTHRSUMFLG|BUSUMMKTGSUMFLG|CROSSOVERSUMNFLSUMCLUBSSUMFLG|LSTSUMFANTASYSUMSSN|LSTSUMSUBSUMPROD|LSTSUMSUBSUMPRODSUMSSN|LSTSUMGPDSUMSUBSUMSSN|LSTSUMGPDSUMFTSUMSSN|LSTSUMGPISUMSUBSUMSSN|LSTSUMGPISUMFTSUMSSN|LSTSUMGPISUMSUBSUMSSNSUMSSN|LSTSUMGPISUMSUBSUMSSNPLSSUMSSN|LSTSUMGPISUMSUBSUMWKLYSUMSSN|LSTSUMGPISUMSUBSUMFYTSUMSSN|LSTSUMMINIGMSUMSSN|LSTSUMMINIGMSUMSSNSUMREGSUMDT|'
    || 'LSTSUMTNFCHSUMSSN|LSTSUMTNFCHSUMSSNSUMREGSUMDT|LSTSUMDRAFTSUMFMPSUMSSN|LSTSUMKICKOFFSUMFMPSUMSSN|LSTSUMSBSUMFMPSUMSSN|LSTSUMPBSUMSTHSUMSSN|LSTSUMPBSUMSTBSUMSSN|SHOPSUMLSTSUMPURCHSUMDT|EMSUMLSTSUMOPENSUMDT|EMSUMLSTSUMCLICKSUMDT|WEBSUMLSTSUMVSTSUMDT|APPSUMLSTSUMVSTSUMDT|FANTASYSUMLSTSUMVSTSUMDT|LSTSUMCLUBSSUMSTHSUMSSN|LSTSUMCLUBSSUMSTBSUMSSN|DTVSUMSUNDAYSUMTICKETSUMFLG|DTVSUMSUNDAYSUMTICKETSUMACTIVESUMFLG|DTVSUMTVSUMFLG|DTVSUMTVSUMACTIVESUMFLG|DTVSUMCOMMERICALSUMFLG|'
    || 'DTVSUMCOMMERICALSUMACTIVESUMFLG|PARENTSUMFLG|TRANSACTIONALSUMVALUE|TSPSUMHHSUMINCOME|NICHE|GPDSUMGPIROWSUMCOUNTRY|GPESUMCOUNTRY|EMSUMNFLNSUMWEEKLYSUMFLG|EMSUMNFLNSUMWEEKLYSUMLSTSUMACTIVTYSUMDT|EMSUMNFLNSUMFLG|EMSUMNFLNSUMLSTSUMACTIVTYSUMDT|EMSUMGMFBSUMFLG|EMSUMGMFBSUMLSTSUMACTIVTYSUMDT|EMSUMTNFSUMFLG|EMSUMTNFSUMLSTSUMACTIVTYSUMDT|EMSUMGDPSUMFLG|EMSUMGDPSUMLSTSUMACTIVITYSUMDT|EMSUMFANTSUMRPTSUMFLG|EMSUMFANTSUMRPTSUMLSTSUMACTIVITYSUMDT|EMSUMFANTSUMCORESUMFLG|EMSUMFANTSUMCORESUMLSTSUMACTIVITYSUMDT|'
    || 'LSTSUMFANTSUMLMSUMSSN|LSTSUMFANTSUMUESUMSSN|LSTSUMFANTSUMCUSTOMSUMSSN|LSTSUMFANTSUMMANAGEDSUMSSN|SHOPSUMYOUTHSUMGIRLSSUMFLG|SHOPSUMYOUTHSUMFLG|PARENTSUMACQUISITIONSUMFLG|YOUTHSUMACQUISITIONSUMFLG|CHILDRENSUMFLG|LSTSUMPTPSUMSSN|NEWSUMTOSUMFCMSUM0SUM3MSUMFLG|FOOTBALLSUMAFFINITYSUMFLG|GPDSUMPAGEVISITSUMFLG|GPDSUMPAGEVISITSUMLSTSUMACTIVITYSUMDT|FANTSUMPAGEVISITSUMFLG|FANTSUMPAGEVISITSUMLSTSUMACTIVITYSUMDT|NFLNSUMAAMSUMSEGMENTSUMFLG|CURRSUMSSNSUMVIDEOSUMVIEWSSUMFLG|'
    || 'GPDSUMSTATUS|GPISUMSTATUS|GPESUMSTATUS|MXSUMOPTSUMINSUMFLAG|DESUMOPTSUMINSUMFLAG|CASUMOPTSUMINSUMFLAG|UKSUMOPTSUMINSUMFLAG|CLUSTERSUMN|CLUSTERSUMPNL|LSTSUMPBSUMFMPSUMSSN|EXTRACTSUMSEQ|HASDKSUMPROBS|SBSPNDSUMPROBS|DRAFTEDSUMFLG|EMAILSUMTIER|TSPSUMZIPSUMCD|TSPSUMSTATESUMABBREVIATION|TSPSUMADDRSUMTYPE|TSPSUMADVSUMHMSUMOWNR|TSPSUMADVSUMHHSUMSIZE|TSPSUMADVSUMHHSUMSIZESUMINDICATOR|TSPSUMADVSUMHHSUMMARITALSUMSTATUS|TSPSUMADVSUMHHSUMMARITALSUMSTATSUMIND|TSPSUMADVSUMDWELLINGSUMTYPE|'
    || 'TSPSUMADVSUMDWELLINGSUMTYPESUMIND|TSPSUMADVSUMTARGETSUMINCOMESUM2|TSPSUMADVSUMTARGETSUMINCOMESUMINDSUM2|TSPSUMADVSUMHHSUMEDUCATION|TSPSUMADVSUMHHSUMEDUCATIONSUMINDICATOR|TSPSUMAGESUMUNK|TSPSUMAGESUM75SUMPLUS|TSPSUMAGESUM65SUM74|TSPSUMAGESUM55SUM64|TSPSUMAGESUM45SUM54|TSPSUMAGESUM35SUM44|TSPSUMAGESUM25SUM34|TSPSUMAGESUM18SUM24|TSPSUMCHILDRENSUMAGESUM0SUM2|TSPSUMCHILDRENSUMAGESUM3SUM5|TSPSUMCHILDRENSUMAGESUM6SUM10|TSPSUMCHILDRENSUMAGESUM11SUM15|TSPSUMCHILDRENSUMAGESUM16SUM17|'
    || 'TSPSUMHHSUMTYPESUMFAMILYSUMCOMP|TSPSUMOCCUPATION|TSPSUMGENDERSUMPRSN|TSPSUMETHNICSUMGRP|TSPSUMETHNICSUMGRPSUMPRSN|TSPSUMLANGUAGESUMPRSN|TSPSUMTARGETSUMVALUESCORESUM2|TSPSUMCCSUMAMERSUMEXPRESS|TSPSUMCCSUMANYSUMCC|TSPSUMCCSUMBANKSUMCARD|TSPSUMCCSUMCATALOGSUMSHOWROOM|TSPSUMCCSUMCOMPUTERSUMELECTRONIC|TSPSUMCCSUMDEBITSUMCARD|TSPSUMCCSUMFINANCESUMCOSUMCARD|TSPSUMCCSUMFURNITURE|TSPSUMCCSUMGROCERY|TSPSUMCCSUMHMSUMIMPROVEMENT|TSPSUMCCSUMHMSUMOFFICESUMSUPPLY|TSPSUMCCSUMLOWSUMENDSUMDEPTSUMSTORE|'
    || 'TSPSUMCCSUMMAINSUMSTREETSUMRETAIL|TSPSUMCCSUMMASTERCARD|TSPSUMCCSUMMBRSHPSUMWHS|TSPSUMCCSUMMISC|TSPSUMCCSUMOILSUMGASSUMCARD|TSPSUMCCSUMSPECIALTYSUMAPPAREL|TSPSUMCCSUMSPORTINGSUMGOODS|TSPSUMCCSUMSTANDARDSUMRETAIL|TSPSUMCCSUMSTANDARDSUMSPECIALTYSUMCARD|TSPSUMCCSUMTRAVELSUMENTERTAINMENT|TSPSUMCCSUMTVSUMMAILSUMORDER|')||'TSPSUMCCSUMUPSCALESUMRETAIL|TSPSUMCCSUMUPSCALESUMSPECSUMRETAIL|TSPSUMCCSUMVISA|TSPSUMMTSUMFOOTBALLSUMENTHUSIASTS|TSPSUMMTSUMSMARTSUMPHONESUMUSER|'
    || 'TSPSUMMTSUMHIGHENDSUMAMSUMRANKSUMTM2|FANTSUMOPPSUMTEAMSUMNMSUMTM2|FANTSUMOPPSUMTEAMSUMRANKSUMTM2|FANTSUMLEAGUESUMIDSUMTM3|FANTSUMTEAMSUMIDSUMTM3|FANTSUMTEAMSUMNMSUMTM3|FANTSUMTEAMSUMRANKSUMTM3|FANTSUMOPPSUMTEAMSUMNMSUMTM3|FANTSUMOPPSUMTEAMSUMRANKSUMTM3|JEBBITSUMATTRIB13SUMFLG|JEBBITSUMATTRIB12SUMFANTSUMFLG|JEBBITSUMATTRIB11SUMKIDSSUMFLG|MSSUMONSUMLOCATION|MSSUMBARCLAY|BARCLAYSUMPASSIONSUMJETSETSUMIND|BARCLAYSUMPASSIONSUMELECSUMIND|BARCLAYSUMPASSIONSUMEGOERSUMIND|LSTSUMGPDSUMSTREAMSUMDT|'
    || 'GPDSUMMINSUMWATCHEDSUMCURRSUMSSN|GPDSUMMINSUMWATCHEDSUMPREV1SUMSSN|GPDSUMMINSUMWATCHEDSUMPREV2SUMSSN|FAVSUMTEAMSUMCDSUMIMPLIED|FAVSUMTEAMSUMCDSUMSUPPLIED|EXTRACTSUMDT' x 
    from dual ;
    spool off;
    exit;
    EOF