/* 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')
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