insert into enterpriseinfo (id,code,enterpriseName,prefecture,plevel,etype) select dw.id,dw.code,dw.name enterpriseName,d.code prefecture,dw.levl plevel,2 etypefrom jyjc.danwei dw left join jyjc.diqu d on d.id = dw.diqu where dw.levl <> 0;
首先，如果两个<em>表</em>结构一样：
insert into <em>表</em>A select * from <em>表</em>B
如果两个<em>表</em>结构不一样：
INSERT INTO <em>表</em>1(字段1,字段2,字段n)
select <em>表</em>2.字段1,<em>表</em>2.字段2,<em>表</em>2.字段n from <em>表</em>2
...
今天想查询一条数据会用到另外一个<em>数据库</em>，想不切换<em>数据库</em>的情况下查询；
create public database link TEST_DBLINK
connect to alibaba identified by qwer1234
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =10.11...
使用db link 把ORACLE <em>数据库</em><em>中</em>的<em>表</em>复制到另外一个<em>数据库</em>，也可以把<em>表</em><em>中</em>的数据从<em>一个库</em>复制到另外<em>一个库</em>的<em>表</em>
<em>数据库</em>1：db1
<em>数据库</em>2：db2
一、下面把db1里面的<em>表</em>，复制到到db2:
1.在db2里面创建db link
create public database link mydblink
connect to scott identified by t
