Can anybody look into this below query? I’m running these below queries on Oracle SQL developer.
Expand|Select|Wrap|Line Numbers
- SELECT * FROM BATCH.ITEM@SCPOREADDB WHERE ITEM LIKE '%82128%'
Expand|Select|Wrap|Line Numbers
- SELECT * FROM EXCEED.CRECOVER@EXERPTDB206 WHERE PROD_ID LIKE '%82128%'
Expand|Select|Wrap|Line Numbers
- 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)) AND I.ITEM LIKE '%82128%'
Expand|Select|Wrap|Line Numbers
- Where PROD_ID is of type CHAR(18bytes) and ITEM is of type VARCHAR2(50Char)
Thanks in advance...