1 2 3 4 5 6
|
SELECT store_some_char(IDFLUX, EMPREINTE, APPLIPUT1, QMPUT1, QAPUT1, APPLIPUT2, QMPUT2 //.... etc...
)
FROM (
SELECT * FROM(SELECT ''29037'' as IDFLUX,'''' as EMPREINTE from dual),(select substr((select qa1.mq_name from link_appli l1,MQ_QUEUEALIAS qa1 where id_application_link=50222 and l1.id_queue=qa1.ID_QUEUEALIAS),instr((select qa1.mq_name from link_appli l1,MQ_QUEUEALIAS qa1 where id_application_link=50222 and l1.id_queue=qa1.ID_QUEUEALIAS),''.'',1,1)+1,instr((select qa1.mq_name from link_appli l1,MQ_QUEUEALIAS qa1 where id_application_link=50222 and l1.id_queue=qa1.ID_QUEUEALIAS),''.'',1,2)-1-instr((select qa1.mq_name from link_appli l1,MQ_QUEUEALIAS qa1 where id_application_link=50222 and l1.id_queue=qa1.ID_QUEUEALIAS),''.'',1,1)) as APPLIPUT1 from DUAL), (SELECT null as QMPUT1 from dual), (SELECT null as QAPUT1 from dual), (SELECT null as APPLIPUT2 from dual), (SELECT null as QMPUT2 from dual), (SELECT null as QAPUT2 from dual), (SELECT null as APPLIPUT3 from dual), (SELECT null as QMPUT3 from dual), (SELECT null as QAPUT3 from dual), (SELECT null as APPLIPUT4 from dual), (SELECT null as QMPUT4 from dual), (SELECT null as QAPUT4 from dual), (SELECT null as APPLIPUT5 from dual), (SELECT null as QMPUT5 from dual), (SELECT null as QAPUT5 from dual), (SELECT null as APPLIPUT6 from dual), (SELECT null as QMPUT6 from dual), (SELECT null as QAPUT6 from dual), (SELECT null as APPLIPUT7 from dual), (SELECT null as QMPUT7 from dual), (SELECT null as QAPUT7 from dual), (SELECT null as APPLIPUT8 from dual), (SELECT null as QMPUT8 from dual), (SELECT null as QAPUT8 from dual), (SELECT null as APPLIPUT9 from dual), (SELECT null as QMPUT9 from dual), (SELECT null as QAPUT9 from dual), (SELECT null as APPLIPUT10 from dual), (SELECT null as QMPUT10 from dual), (SELECT null as QAPUT10 from dual), (SELECT null as APPLIPUT11 from dual), (SELECT null as QMPUT11 from dual), (SELECT null as QAPUT11 from dual), (SELECT null as APPLIPUT12 from dual), (SELECT null as QMPUT12 from dual), (SELECT null as QAPUT12 from dual), (SELECT null as APPLIPUT13 from dual), (SELECT null as QMPUT13 from dual), (SELECT null as QAPUT13 from dual), (SELECT null as APPLIPUT14 from dual), (SELECT null as QMPUT14 from dual), (SELECT null as QAPUT14 from dual), (SELECT null as APPLIPUT15 from dual), (SELECT null as QMPUT15 from dual), (SELECT null as QAPUT15 from dual), (SELECT null as APPLIPUT16 from dual), (SELECT null as QMPUT16 from dual), (SELECT null as QAPUT16 from dual), (SELECT null as APPLIPUT17 from dual), (SELECT null as QMPUT17 from dual), (SELECT null as QAPUT17 from dual), (SELECT null as APPLIPUT18 from dual), (SELECT null as QMPUT18 from dual), (SELECT null as QAPUT18 from dual), (SELECT null as APPLIPUT19 from dual), (SELECT null as QMPUT19 from dual), (SELECT null as QAPUT19 from dual), (SELECT null as APPLIPUT20 from dual), (SELECT null as QMPUT20 from dual), (SELECT null as QAPUT20 from dual), (SELECT null as APPLIPUT21 from dual), (SELECT null as QMPUT21 from dual), (SELECT null as QAPUT21 from dual), (SELECT null as APPLIPUT22 from dual), (SELECT null as QMPUT22 from dual), (SELECT null as QAPUT22 from dual), (SELECT null as APPLIPUT23 from dual), (SELECT null as QMPUT23 from dual), (SELECT null as QAPUT23 from dual), (SELECT null as APPLIPUT24 from dual), (SELECT null as QMPUT24 from dual), (SELECT null as QAPUT24 from dual), (SELECT null as APPLIPUT25 from dual), (SELECT null as QMPUT25 from dual), (SELECT null as QAPUT25 from dual), (SELECT null as APPLIPUT26 from dual), (SELECT null as QMPUT26 from dual), (SELECT null as QAPUT26 from dual), (SELECT null as APPLIPUT27 from dual), (SELECT null as QMPUT27 from dual), (SELECT null as QAPUT27 from dual), (SELECT null as APPLIPUT28 from dual), (SELECT null as QMPUT28 from dual), (SELECT null as QAPUT28 from dual), (SELECT null as APPLIPUT29 from dual), (SELECT null as QMPUT29 from dual), (SELECT null as QAPUT29 from dual), (SELECT null as APPLIPUT30 from dual), (SELECT null as QMPUT30 from dual), (SELECT null as QAPUT30 from dual), (SELECT null as APPLIPUT31 from dual), (SELECT null as QMPUT31 from dual), (SELECT null as QAPUT31 from dual), (SELECT null as APPLIPUT32 from dual), (SELECT null as QMPUT32 from dual), (SELECT null as QAPUT32 from dual), (SELECT null as APPLIPUT33 from dual), (SELECT null as QMPUT33 from dual), (SELECT null as QAPUT33 from dual),(select app.code as APPLIGET1 from link_appli l1,application app where l1.id_application_link=50222 and app.id_application=l1.id_application) c1GET,(select qm1.mq_name as QMGET1 from link_appli l1,MQ_QUEUEALIAS qa1, MQ_QMANAGER qm1 where id_application_link=50222 and l1.id_queue=qa1.ID_QUEUEALIAS AND qa1.ID_QMANAGER=qm1.id_qmanager) QM1GET,(select qa1.mq_name as QAPGET1 from link_appli l1,MQ_QUEUEALIAS qa1 where id_application_link=50222 and l1.id_queue=qa1.ID_QUEUEALIAS) QA1GET, (SELECT null as APPLIGET2 from dual), (SELECT null as QMGET2 from dual), (SELECT null as QAGET2 from dual), (SELECT null as APPLIGET3 from dual), (SELECT null as QMGET3 from dual), (SELECT null as QAGET3 from dual), (SELECT null as APPLIGET4 from dual), (SELECT null as QMGET4 from dual), (SELECT null as QAGET4 from dual), (SELECT null as APPLIGET5 from dual), (SELECT null as QMGET5 from dual), (SELECT null as QAGET5 from dual), (SELECT null as APPLIGET6 from dual), (SELECT null as QMGET6 from dual), (SELECT null as QAGET6 from dual), (SELECT null as APPLIGET7 from dual), (SELECT null as QMGET7 from dual), (SELECT null as QAGET7 from dual), (SELECT null as APPLIGET8 from dual), (SELECT null as QMGET8 from dual), (SELECT null as QAGET8 from dual), (SELECT null as APPLIGET9 from dual), (SELECT null as QMGET9 from dual), (SELECT null as QAGET9 from dual), (SELECT null as APPLIGET10 from dual), (SELECT null as QMGET10 from dual), (SELECT null as QAGET10 from dual), (SELECT null as APPLIGET11 from dual), (SELECT null as QMGET11 from dual), (SELECT null as QAGET11 from dual), (SELECT null as APPLIGET12 from dual), (SELECT null as QMGET12 from dual), (SELECT null as QAGET12 from dual), (SELECT null as APPLIGET13 from dual), (SELECT null as QMGET13 from dual), (SELECT null as QAGET13 from dual), (SELECT null as APPLIGET14 from dual), (SELECT null as QMGET14 from dual), (SELECT null as QAGET14 from dual), (SELECT null as APPLIGET15 from dual), (SELECT null as QMGET15 from dual), (SELECT null as QAGET15 from dual), (SELECT null as APPLIGET16 from dual), (SELECT null as QMGET16 from dual), (SELECT null as QAGET16 from dual), (SELECT null as APPLIGET17 from dual), (SELECT null as QMGET17 from dual), (SELECT null as QAGET17 from dual), (SELECT null as APPLIGET18 from dual), (SELECT null as QMGET18 from dual), (SELECT null as QAGET18 from dual), (SELECT null as APPLIGET19 from dual), (SELECT null as QMGET19 from dual), (SELECT null as QAGET19 from dual), (SELECT null as APPLIGET20 from dual), (SELECT null as QMGET20 from dual), (SELECT null as QAGET20 from dual), (SELECT null as APPLIGET21 from dual), (SELECT null as QMGET21 from dual), (SELECT null as QAGET21 from dual), (SELECT null as APPLIGET22 from dual), (SELECT null as QMGET22 from dual), (SELECT null as QAGET22 from dual), (SELECT null as APPLIGET23 from dual), (SELECT null as QMGET23 from dual), (SELECT null as QAGET23 from dual), (SELECT null as APPLIGET24 from dual), (SELECT null as QMGET24 from dual), (SELECT null as QAGET24 from dual), (SELECT null as APPLIGET25 from dual), (SELECT null as QMGET25 from dual), (SELECT null as QAGET25 from dual), (SELECT null as APPLIGET26 from dual), (SELECT null as QMGET26 from dual), (SELECT null as QAGET26 from dual), (SELECT null as APPLIGET27 from dual), (SELECT null as QMGET27 from dual), (SELECT null as QAGET27 from dual), (SELECT null as APPLIGET28 from dual), (SELECT null as QMGET28 from dual), (SELECT null as QAGET28 from dual), (SELECT null as APPLIGET29 from dual), (SELECT null as QMGET29 from dual), (SELECT null as QAGET29 from dual), (SELECT null as APPLIGET30 from dual), (SELECT null as QMGET30 from dual), (SELECT null as QAGET30 from dual), (SELECT null as APPLIGET31 from dual), (SELECT null as QMGET31 from dual), (SELECT null as QAGET31 from dual), (SELECT null as APPLIGET32 from dual), (SELECT null as QMGET32 from dual), (SELECT null as QAGET32 from dual), (SELECT null as APPLIGET33 from dual), (SELECT null as QMGET33 from dual), (SELECT null as QAGET33 from dual)
) |
Partager