oracle insert into select写法
INSERT INTO T_MONITOR_USER_INFO (METER_NO,CONSUMER_NO,USER_INFO,COURT_ID)select * from(select distinctMETER_NO,CONSUMER_NO,'wy' as USER_INFO,EPU_COURT as COURT_ID from T_METER where C_DISTRICTBCDID in (select DISTINCTDISTRICTBCDIDfrom ..
原创
2021-09-17 15:10:49 ·
18452 阅读 ·
0 评论