Обсуждение: DB Link Question

is there away to check with DB Link if one record exists/not exists in a remote database?

Something like...

SELECT item_id FROM TABLE A WHERE NOT EXISTS (SELECT 1 FROM TABLE B WHERE A.item_id=B.item_id)

Where Table A is on a Local machine and Table B is on a remote machine.

Thanks for any help on that.

Alex