SQL Language (MOSC)

MOSC Banner

scope of an alias in an query using dblink

edited Jul 26, 2016 5:04AM in SQL Language (MOSC) 4 commentsAnswered

QUERY A

SELECT DISTINCT A.EMPLID FROM PS_BAS_PARTIC A

WHERE NOT EXISTS (SELECT 'X' FROM SYSADM.PS_RC_CASE@HCMTOCRM

                  WHERE SYSADM.PS_RC_CASE.BO_ID_CUST=

                                        (SELECT SYSADM.PS_RD_PERSON.BO_ID FROM SYSADM.PS_RD_PERSON@HCMTOCRM

                                         WHERE SYSADM.PS_RD_PERSON.EMPLID= A.EMPLID));

QUERY B

SELECT DISTINCT A.EMPLID FROM PS_BAS_PARTIC A

WHERE NOT EXISTS (SELECT 'X' FROM SYSADM.PS_RC_CASE@HCMTOCRM

                  WHERE SYSADM.PS_RC_CASE.BO_ID_CUST=

                                        (SELECT SYSADM.PS_RD_PERSON.BO_ID FROM SYSADM.PS_RD_PERSON@HCMTOCRM

                                         WHERE SYSADM.PS_RD_PERSON.EMPLID=

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center