Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> problem while execuitng query using DB Link.
Hi while executing this dblink query the toad is hangs so please tell
me ia there anything wrong with this query
INSERT INTO DEST_DUPLI_MESSAGE_at_ltsb.us.oracle.com
(TXN_ID,COUNTRY_CODE,TXN_SOURCE,DEST_CODE,IN_TIME,DUPLI_MESSAGE_ID,MESSAGE)
(SELECT
TXN_ID,COUNTRY_CODE,TXN_SOURCE,DEST_CODE,IN_TIME,DUPLI_MESSAGE_ID,MESSAGE
FROM DEST_DUPLI_MESSAGE WHERE TXN_ID IN (SELECT TXN_ID FROM TEMP))
Received on Wed Mar 28 2007 - 05:09:35 CDT