SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query returns different results

User_VKU4XApr 4 2018 — edited Apr 12 2018

I have a weird problem with a query in one of our test environments. It returns different counts every time I run the query. I checked the security tables and they look good and the count in all the related tables are static and do not change at any time.The stats are up to date.

Please suggest as to what things I need to look to identify the cause for this. Thanks

SELECT COUNT(*) FROM
PS_BAS_PARTIC A, PS_EMPLMT_SRCH_QRY A1

WHERE A.EMPLID = A1.EMPLID

AND A1.OPRID = 'JOHN'

AND A.EMPL_RCD=A1.EMPL_RCD

AND A.SCHED_ID IN ('OE14','EM','OE15','OE16','OE17','OE18')

AND A.JOB_ELIG_CHG = 'Y'

Locked Post

New comments cannot be posted to this locked post.

Locked on May 10 2018

Added on Apr 4 2018

38 comments

3,804 views