Salto de carro en queries dinámicas
Publicado por Maria Rosa (1 intervención) el 24/04/2007 13:37:55
Hola a todos, estoy intentado hacer una query en base de datos tal que así:
select 'insert /*+ APPEND*/ into '|| t.table_name || ' (select * from '||t.table_name||'@dwhint);'||chr(13)||chr(10)||'commit;'
from user_all_tables t where t.table_name like 'RPST_DISPLAY%';
debido a l CHR(13) en el resultado aparecen al principio y final de la quetry un a comillas dobles que no me permiten ejecutar el script, cómo puedo solucionarlo?.
Lo que hay a continuación es el resultado de la query:
"insert /*+ APPEND*/ into RPST_DISPLAY11_AGPRODUCTO (select * from RPST_DISPLAY11_AGPRODUCTO@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY11_AGPRODUCTO_SEG (select * from RPST_DISPLAY11_AGPRODUCTO_SEG@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY11_DESCPRODUCTO (select * from RPST_DISPLAY11_DESCPRODUCTO@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY11_PRODUCTO (select * from RPST_DISPLAY11_PRODUCTO@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY11_PRODUCTO_SEG (select * from RPST_DISPLAY11_PRODUCTO_SEG@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY6_ALTAS (select * from RPST_DISPLAY6_ALTAS@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY6_ALTAS_HIST (select * from RPST_DISPLAY6_ALTAS_HIST@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY6_ANULA (select * from RPST_DISPLAY6_ANULA@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY6_ANULA_CARGA (select * from RPST_DISPLAY6_ANULA_CARGA@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY6_CANAL (select * from RPST_DISPLAY6_CANAL@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY6_CFG (select * from RPST_DISPLAY6_CFG@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY6_DZS (select * from RPST_DISPLAY6_DZS@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY6_GRUPOS (select * from RPST_DISPLAY6_GRUPOS@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY6_SUBCANAL (select * from RPST_DISPLAY6_SUBCANAL@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY8_AGENCIA (select * from RPST_DISPLAY8_AGENCIA@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY9_HERRAMIENTAS (select * from RPST_DISPLAY9_HERRAMIENTAS@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_AGENCIA_ECOMMERCE (select * from RPST_DISPLAY_AGENCIA_ECOMMERCE@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_ALTAS_TODO (select * from RPST_DISPLAY_ALTAS_TODO@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_ALTAS_TODO_LOG (select * from RPST_DISPLAY_ALTAS_TODO_LOG@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_ALTAS_TODO_SEG (select * from RPST_DISPLAY_ALTAS_TODO_SEG@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_ANULA_AUTO_P1 (select * from RPST_DISPLAY_ANULA_AUTO_P1@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_ANULA_DIARIOP1 (select * from RPST_DISPLAY_ANULA_DIARIOP1@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_ANULA_P1HOST (select * from RPST_DISPLAY_ANULA_P1HOST@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_CARGA_BATCH (select * from RPST_DISPLAY_CARGA_BATCH@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_DATA_GRUPOS (select * from RPST_DISPLAY_DATA_GRUPOS@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_DATA_GRUPOS_HIST (select * from RPST_DISPLAY_DATA_GRUPOS_HIST@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_DELEGACIONES (select * from RPST_DISPLAY_DELEGACIONES@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_FUNCIONES (select * from RPST_DISPLAY_FUNCIONES@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_LASTACT (select * from RPST_DISPLAY_LASTACT@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_LOG_CARGA (select * from RPST_DISPLAY_LOG_CARGA@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_P1_ABR05 (select * from RPST_DISPLAY_P1_ABR05@dwhint);
commit;"
Saludos y gracias.
select 'insert /*+ APPEND*/ into '|| t.table_name || ' (select * from '||t.table_name||'@dwhint);'||chr(13)||chr(10)||'commit;'
from user_all_tables t where t.table_name like 'RPST_DISPLAY%';
debido a l CHR(13) en el resultado aparecen al principio y final de la quetry un a comillas dobles que no me permiten ejecutar el script, cómo puedo solucionarlo?.
Lo que hay a continuación es el resultado de la query:
"insert /*+ APPEND*/ into RPST_DISPLAY11_AGPRODUCTO (select * from RPST_DISPLAY11_AGPRODUCTO@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY11_AGPRODUCTO_SEG (select * from RPST_DISPLAY11_AGPRODUCTO_SEG@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY11_DESCPRODUCTO (select * from RPST_DISPLAY11_DESCPRODUCTO@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY11_PRODUCTO (select * from RPST_DISPLAY11_PRODUCTO@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY11_PRODUCTO_SEG (select * from RPST_DISPLAY11_PRODUCTO_SEG@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY6_ALTAS (select * from RPST_DISPLAY6_ALTAS@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY6_ALTAS_HIST (select * from RPST_DISPLAY6_ALTAS_HIST@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY6_ANULA (select * from RPST_DISPLAY6_ANULA@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY6_ANULA_CARGA (select * from RPST_DISPLAY6_ANULA_CARGA@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY6_CANAL (select * from RPST_DISPLAY6_CANAL@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY6_CFG (select * from RPST_DISPLAY6_CFG@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY6_DZS (select * from RPST_DISPLAY6_DZS@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY6_GRUPOS (select * from RPST_DISPLAY6_GRUPOS@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY6_SUBCANAL (select * from RPST_DISPLAY6_SUBCANAL@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY8_AGENCIA (select * from RPST_DISPLAY8_AGENCIA@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY9_HERRAMIENTAS (select * from RPST_DISPLAY9_HERRAMIENTAS@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_AGENCIA_ECOMMERCE (select * from RPST_DISPLAY_AGENCIA_ECOMMERCE@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_ALTAS_TODO (select * from RPST_DISPLAY_ALTAS_TODO@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_ALTAS_TODO_LOG (select * from RPST_DISPLAY_ALTAS_TODO_LOG@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_ALTAS_TODO_SEG (select * from RPST_DISPLAY_ALTAS_TODO_SEG@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_ANULA_AUTO_P1 (select * from RPST_DISPLAY_ANULA_AUTO_P1@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_ANULA_DIARIOP1 (select * from RPST_DISPLAY_ANULA_DIARIOP1@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_ANULA_P1HOST (select * from RPST_DISPLAY_ANULA_P1HOST@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_CARGA_BATCH (select * from RPST_DISPLAY_CARGA_BATCH@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_DATA_GRUPOS (select * from RPST_DISPLAY_DATA_GRUPOS@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_DATA_GRUPOS_HIST (select * from RPST_DISPLAY_DATA_GRUPOS_HIST@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_DELEGACIONES (select * from RPST_DISPLAY_DELEGACIONES@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_FUNCIONES (select * from RPST_DISPLAY_FUNCIONES@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_LASTACT (select * from RPST_DISPLAY_LASTACT@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_LOG_CARGA (select * from RPST_DISPLAY_LOG_CARGA@dwhint);
commit;"
"insert /*+ APPEND*/ into RPST_DISPLAY_P1_ABR05 (select * from RPST_DISPLAY_P1_ABR05@dwhint);
commit;"
Saludos y gracias.
Valora esta pregunta


0