I was trying to run the query with like operator but it showing zero rows
FROM LPU@PDB.SGCPA93_FSA_VINPRE A
,LPU@PDB.SGCPA16_GLBFSAHUB B
WHERE GCPA13_UPDATE_S LIKE '2013-10-18%' AND A.GCPA15_GLOBL_FSA_R = B.GCPA15_GLOBL_FSA_R
AND B.GCPA16_LAUNCH_Y > '2008-12-31'
,LPU@PDB.SGCPA16_GLBFSAHUB B
WHERE GCPA13_UPDATE_S LIKE '2013-10-18%' AND A.GCPA15_GLOBL_FSA_R = B.GCPA15_GLOBL_FSA_R
AND B.GCPA16_LAUNCH_Y > '2008-12-31'
Can you please advise any one on this