Search This Blog

Saturday, November 25, 2017

Location Query

/* Formatted on 9/25/2017 4:12:35 PM (QP5 v5.163.1008.3004) */
SELECT LOCATION_NAME,
       iNTERNAL_LOCATION_CODE,
       TO_CHAR (EFFECTIVE_START_DATE,
                'DD-Mon-YYYY',
                'NLS_DATE_LANGUAGE=AMERICAN')
          "Effective Start Date",
       POSTAL_CODE,
       COUNTRY, ADDRESS_LINE_1,
       ADDRESS_LINE_2
  FROM hr_locations
 --WHERE iNTERNAL_LOCATION_CODE in ('225','203')

No comments:

Post a Comment