Can anybody look into this below query? I’m running these below queries on Oracle SQL developer.
Code:
SELECT * FROM BATCH.ITEM@SCPOREADDB WHERE ITEM LIKE '%82128%'
Code:
SELECT * FROM EXCEED.CRECOVER@EXERPTDB206 WHERE PROD_ID LIKE '%82128%'
Code:
SELECT C.PROD_ID, I.UDC_BDMNAME, I.ITEM FROM EXCEED.CRECOVER@EXERPTDB206 C INNER JOIN BATCH.ITEM@SCPOREADDB I ON TO_CHAR(TRIM(C.PROD_ID)) = TO_CHAR(TRIM(I.ITEM))