VIEW: APPS.DDR_R_GEO_DEMOG_OPT_V

Source

View Text - Preformatted

SELECT MFG_ORG_CD,GEO_DEMOG_ID,GEO_CD,GEO_VAL,GEO_DESC,ISO_CNTRY_CD,FMLY_TYP_CD,FMLY_TYP_CD_DESC,EDU_LVL_CD,EDU_LVL_CD_DESC,INDSTRY_CD,INDSTRY_CD_DESC,ANCSTRY_CD,ANCSTRY_CD_DESC,ML_TO_FML_RATIO,URBN_TO_RURAL_RATIO,MEDIAN_COMUT_TIME,AUTO_AVLBLTY_NBR,TOT_POPLTN,PVRTY_TOT,RENT_TO_OWN_RATIO,MEDIAN_RTRMNT_INCM,AVG_RM_NBR_PER_HM,AVG_HSNG_VAL,AVG_HM_BLT_YR,POPLTN_DNSTY,POPLTN_DNSTY_UOM_CD,POPLTN_RATIO_WHT,POPLTN_RATIO_BLK,POPLTN_RATIO_ASIAN,POPLTN_RATIO_HSPNIC,POPLTN_RATIO_OTHR,POPLTN_MEDIAN_AGE,HH_MEDIAN_SZ,HH_MEDIAN_INCM,HH_AVG_INCM,HH_PER_CPT_INCM,ANNUAL_HTNG_DEG_DAYS,ANNUAL_PRCPTN,ANNUAL_AVG_SNOWFL,AVG_NBR_OF_DAYS_SNOW,AVG_NBR_OF_DAYS_CLR,AVG_NBR_OF_DAYS_RAIN,CRIME_INDX,EFF_FROM_DT,EFF_TO_DT FROM DDR_R_GEO_DEMOG UNION SELECT '-1',-1,'-1','-1','-1','-1','-1','-1','-1','-1','-1','-1','-1','-1',-1,-1,-1,'-1',-1,-1,-1,-1,-1,-1,-1,-1,'-1',-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,TO_DATE('01-JAN-1900','DD-MON-YYYY') as EFF_FROM_DT, TO_DATE('01-JAN-2400','DD-MON-YYYY') as EFF_TO_DT FROM DUAL

View Text - HTML Formatted

SELECT MFG_ORG_CD
, GEO_DEMOG_ID
, GEO_CD
, GEO_VAL
, GEO_DESC
, ISO_CNTRY_CD
, FMLY_TYP_CD
, FMLY_TYP_CD_DESC
, EDU_LVL_CD
, EDU_LVL_CD_DESC
, INDSTRY_CD
, INDSTRY_CD_DESC
, ANCSTRY_CD
, ANCSTRY_CD_DESC
, ML_TO_FML_RATIO
, URBN_TO_RURAL_RATIO
, MEDIAN_COMUT_TIME
, AUTO_AVLBLTY_NBR
, TOT_POPLTN
, PVRTY_TOT
, RENT_TO_OWN_RATIO
, MEDIAN_RTRMNT_INCM
, AVG_RM_NBR_PER_HM
, AVG_HSNG_VAL
, AVG_HM_BLT_YR
, POPLTN_DNSTY
, POPLTN_DNSTY_UOM_CD
, POPLTN_RATIO_WHT
, POPLTN_RATIO_BLK
, POPLTN_RATIO_ASIAN
, POPLTN_RATIO_HSPNIC
, POPLTN_RATIO_OTHR
, POPLTN_MEDIAN_AGE
, HH_MEDIAN_SZ
, HH_MEDIAN_INCM
, HH_AVG_INCM
, HH_PER_CPT_INCM
, ANNUAL_HTNG_DEG_DAYS
, ANNUAL_PRCPTN
, ANNUAL_AVG_SNOWFL
, AVG_NBR_OF_DAYS_SNOW
, AVG_NBR_OF_DAYS_CLR
, AVG_NBR_OF_DAYS_RAIN
, CRIME_INDX
, EFF_FROM_DT
, EFF_TO_DT
FROM DDR_R_GEO_DEMOG UNION SELECT '-1'
, -1
, '-1'
, '-1'
, '-1'
, '-1'
, '-1'
, '-1'
, '-1'
, '-1'
, '-1'
, '-1'
, '-1'
, '-1'
, -1
, -1
, -1
, '-1'
, -1
, -1
, -1
, -1
, -1
, -1
, -1
, -1
, '-1'
, -1
, -1
, -1
, -1
, -1
, -1
, -1
, -1
, -1
, -1
, -1
, -1
, -1
, -1
, -1
, -1
, -1
, TO_DATE('01-JAN-1900'
, 'DD-MON-YYYY') AS EFF_FROM_DT
, TO_DATE('01-JAN-2400'
, 'DD-MON-YYYY') AS EFF_TO_DT
FROM DUAL