Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
MERGE INTO TEST.CONTCT D USING (select WHOLENAME, FIRST_NAME, LAST_NAME, ADUSERNAME, EMAIL, PHONENUMBER, LOCATION1, DEPARTMENT, COMPANY, STATUS, LOCATION_L7 from ( SELECT P7.WHOLENAME, P7.FIRST_NAME, P7.LAST_NAME, P7.ADUSERNAME, P7.EMAIL, P7.PHONENUMBER, P7.LOCATION1, P7.DEPARTMENT, P7.COMPANY, P7.STATUS,L7."LOCATION" AS LOCATION_L7, row_number() over(partition by P7.ADUSERNAME order by P7.ADUSERNAME) AS RN FROM LNOTES_EXP P7, TEST.LOCM1 L7 WHERE L7.LOCATION_NAME = P7.LOCATION1 AND P7.ADUSERNAME is not null ) where RN = 1 ) P ON (UPPER(P.ADUSERNAME) = D.CONTACT_NAME) WHEN MATCHED THEN UPDATE SET D.FULL_NAME = P.WHOLENAME, D.FIRST_NAME = P.FIRST_NAME, D.LAST_NAME = P.LAST_NAME, D.EMAIL = P.EMAIL, D.CONTACT_PHONE = P.PHONENUMBER, D."LOCATION" = P.LOCATION_L7 , D.DEPT_NAME = P.DEPARTMENT , D.COMPANY = 'EMG', D.ACTIVE = DECODE(UPPER(P.STATUS),'ACTIVE','Y','N') WHEN NOT MATCHED THEN INSERT (D.FULL_NAME, D.CONTACT_NAME, D.USER_ID, D.FIRST_NAME, D.LAST_NAME, D.OPERATOR_ID, D.EMAIL, D.CONTACT_PHONE ,D."LOCATION", D.DEPT_NAME, D.COMPANY, D.ACTIVE) VALUES (P.WHOLENAME, UPPER(P.ADUSERNAME), UPPER(P.ADUSERNAME), P.FIRST_NAME, P.LAST_NAME, P.ADUSERNAME, P.EMAIL, P.PHONENUMBER, P."LOCATION_L7", P.DEPARTMENT, 'EMG', DECODE(UPPER(P.STATUS),'ACTIVE','Y','N')); COMMIT;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.