El TecnoBaúl de Kiquenet

Kiquenet boring stories

Posts Tagged ‘dblink’

DBLink Oracle for Insert Select

Posted by kiquenet en 10 octubre 2014


DBLink to PRE is defined in DEV.

DBLink not support BLOB field.

Now, SQL Insert Select for get rows from PRE to DEV:

insert into  SCHEMA01.LOGS (IDPRO, DateLog, res, idserv, user, machine, etiq, pet, LOG)
SELECT 110940, DateLog, res, 53705, user, machine, etiq, pet, EMPTY_BLOB()  FROM SCHEMA01.LOGS@PRE
where etiq is not null  AND machine LIKE ‘OPERATORS%’ and RESULT = ‘KO’

Insert into SCHEMA01.CODES Select * from SCHEMA01.CODES@PRE

Posted in Oracle | Etiquetado: , , | Leave a Comment »