DBA Data[Home] [Help]

VIEW: HR.PAY_US_CITY_NAMES#

Source

View Text - Preformatted

select CITY_NAME CITY_NAME, STATE_CODE STATE_CODE, COUNTY_CODE COUNTY_CODE, CITY_CODE CITY_CODE, PRIMARY_FLAG PRIMARY_FLAG, DISABLE DISABLE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, ZD_EDITION_NAME ZD_EDITION_NAME from "HR"."PAY_US_CITY_NAMES"
View Text - HTML Formatted

SELECT CITY_NAME CITY_NAME
, STATE_CODE STATE_CODE
, COUNTY_CODE COUNTY_CODE
, CITY_CODE CITY_CODE
, PRIMARY_FLAG PRIMARY_FLAG
, DISABLE DISABLE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "HR"."PAY_US_CITY_NAMES"