欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

oracle插入O2O_SHOP_INFO_LS

程序员文章站 2022-07-08 12:38:04
...

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'
相关标签: Oracle