`

oracle插入O2O_SHOP_INFO_LS

阅读更多

insert into O2O_SHOP_INFO_LS  (SHOP_NAME, SHOP_URL, AREA, PHONE, ADDRESS, EV_NUM, BAD_NUM, SCORE, PT_NAME, FP, OPEN_DATE, CITY, LAST_DATE,
SALES, CODE, MT_SEACH_URL, COMPANY_NAME, MT_PHONE, MT_ADDRESS, DZDP_SHOP_NAME, DZDP_SHOP_URL, DZDP_ADDRESS,
DZDP_PL, DZDP_OPEN_DATE, DZDP_PHONE, DZDP_WM, DZDP_ZZ, IS_CERT, ADDRESS_CODE, IS_YYZZ, IS_XKZ,
PUB_GRADE, XIAOQV, LON, LAT, UPDATE_ZT, IMG_ZZ_COUNT, PC, IS_LHFJ, CSDJ, GLDJ, JCRQ, DWMC, XKZH, FDDBR,
JYDZ, ZTYT, JYFW, YXQ, FL, INSERTDATE, DEATH, IMG_URL, SHOP_NAME2, PROVINCE1, CITY1, CITYCODE, DISTRICT,
ADCODE, LATITUDE, LONGITUDE, CHECK_DATE, CHECK_RESULT, AUTHENTIC_ID, ISPPXKZ, IS_XKZGQ, IS_CFWJY, IS_YZDY, ZT)
select
SHOP_NAME, SHOP_URL, AREA, PHONE, ADDRESS, EV_NUM, BAD_NUM, SCORE, PT_NAME, FP, OPEN_DATE, CITY, LAST_DATE,
SALES, CODE, MT_SEACH_URL, COMPANY_NAME, MT_PHONE, MT_ADDRESS, DZDP_SHOP_NAME, DZDP_SHOP_URL, DZDP_ADDRESS,
DZDP_PL, DZDP_OPEN_DATE, DZDP_PHONE, DZDP_WM, DZDP_ZZ, IS_CERT, ADDRESS_CODE, IS_YYZZ, IS_XKZ,
PUB_GRADE, XIAOQV, LON, LAT, UPDATE_ZT, IMG_ZZ_COUNT, PC, IS_LHFJ, CSDJ, GLDJ, JCRQ, DWMC, XKZH, FDDBR,
JYDZ, ZTYT, JYFW, YXQ, FL, INSERTDATE, DEATH, IMG_URL, SHOP_NAME2, PROVINCE1, CITY1, CITYCODE, DISTRICT,
ADCODE, LATITUDE, LONGITUDE, CHECK_DATE, CHECK_RESULT, AUTHENTIC_ID, ISPPXKZ, IS_XKZGQ, IS_CFWJY, IS_YZDY, ZT
from o2o_shop_info_app where city1='三亚市'  and zt='1'
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics