機械翻訳について

CN_GEOGRAPHIES_V

詳細

• スキーマ: FUSION

• オブジェクト所有者: CN

• オブジェクト・タイプ: VIEW

列

名前
MEANING GEOGRAPHY_NAME GEOGRAPHY_TYPE GEOGRAPHY_USE GEOGRAPHY_CODE

問合せ

SQL_Statement

SELECT DECODE(GEOGRAPHY_ELEMENT10,NULL,NULL,GEOGRAPHY_ELEMENT10||',') || DECODE(GEOGRAPHY_ELEMENT9,NULL,NULL,GEOGRAPHY_ELEMENT9||',') || DECODE(GEOGRAPHY_ELEMENT8,NULL,NULL,GEOGRAPHY_ELEMENT8||',') || DECODE(GEOGRAPHY_ELEMENT7,NULL,NULL,GEOGRAPHY_ELEMENT7||',') || DECODE(GEOGRAPHY_ELEMENT6,NULL,NULL,GEOGRAPHY_ELEMENT6||',') || DECODE(GEOGRAPHY_ELEMENT5,NULL,NULL,GEOGRAPHY_ELEMENT5||',') || DECODE(GEOGRAPHY_ELEMENT4,NULL,NULL,GEOGRAPHY_ELEMENT4||',') || DECODE(GEOGRAPHY_ELEMENT3,NULL,NULL,GEOGRAPHY_ELEMENT3||',') || DECODE(GEOGRAPHY_ELEMENT2,NULL,NULL,GEOGRAPHY_ELEMENT2||',') || GEOGRAPHY_ELEMENT1 meaning, geography_name geography_name, geography_type geography_type, geography_use geography_use, geography_code geography_code FROM hz_geographies