-
编辑 删除
insert into select and select insert into
create talbe test1 (sendto varchar(50), name1 varchar(50), name2 varchar(50))insert into kafa.test1 (sendto, name1, name2) SELECT sendto, name1, name2 FROM (SELECT DISTINCT sendto as sendto, p.name as name1, r.name as name2 FROM smsreport s left join kafa.region r on s.region_id = r.id left join kafa.region p on s.province_id = p.id ) 不需要创建表test1SELECT sendto, name1, name2 insert into test1 FROM (SELECT DISTINCT sendto as sendto, p.name as name1, r.name as name2 FROM smsreport s left join
-
编辑 删除
TNS-12535: TNS：操作超时 错误解释
系统环境: windows server 2003 enterprise edition sp1oralce 8i在sqlplus /nolog下执行:SQL> connect sys/change_on_install@ORA8I as sysdba;ERROR：ORA-12535: TNS: 操作超时备忘解释:在DBA studio中检查网络服务名为ORA8I_192.168.1.101，移去后重新添加ORA8I到树,网络服务名改为ORA8I,再次登录后成功。[@more@]
-
博文量8
-
访问量17734
