DBA Data[Home] [Help]

VIEW: APPS.MST_MD_HYDROS_V

Source

View Text - Preformatted

SELECT hydros.hydrography_id, hydros.feature_code, hydros.inst_style_id, hydros.area, hydros.geometry, names.name from mst_md_hydros hydros, mst_md_names names WHERE hydros.hydrography_id = names.name_id
View Text - HTML Formatted

SELECT HYDROS.HYDROGRAPHY_ID
, HYDROS.FEATURE_CODE
, HYDROS.INST_STYLE_ID
, HYDROS.AREA
, HYDROS.GEOMETRY
, NAMES.NAME
FROM MST_MD_HYDROS HYDROS
, MST_MD_NAMES NAMES
WHERE HYDROS.HYDROGRAPHY_ID = NAMES.NAME_ID