oracleÁ½ÕÅÊý¾Ý±íµÄ³éÈ¥ÎÊÌâ - Oracle / ¿ª·¢

Á½ÕÅÏàͬµÄÊý¾Ý±í£¨½á¹¹Ïàͬ£©A±í¡¢B±í

ÎÒ´Ó±íAÖвéѯµ½µÄÊý¾Ý±£´æµ½Ò»¸öDataset ÀȻºó°ÑDatasetÀïÃæµÄÊý¾ÝÈ«²¿Ìí¼Óµ½BÀïÔõôʵÏÖ¡£
ÎÒÕâÑùʵÏÖÔõô´ÓA±í²éѯµ½µÄÊý¾ÝÌí¼Ó²»µ½BÀïÈ¥ÄØ£¿

DataSet dsExp = Query(conExp,sqlExp);ÕâÒ»²½Ã»ÎÊÌâÊý¾Ý¿ÉÒÔ»ñÈ¡µ½¡£

String sql="select * from jp_kss";
OracleDataAdapter command =new OracleDataAdapter(sql,conn);
OracleCommandBuilder custcb =new OracleCommandBuilder(command);
conn.Open();
command.fill(dsExp);
command.Update(dsExp);
conn.Close();

---

insert into B
SELECT * from A ;

---

Á½ÕÅ±í²»²»ÔÙͬһ¸öʵÀýÀï²»ÄÜÓÃinsert into

---

ÒýÓÃ

Á½ÕÅ±í²»²»ÔÙͬһ¸öʵÀýÀï²»ÄÜÓÃinsert into

¿ÉÒÔ£¬Ç°ÌáÊÇÒª´´½¨Ò»¸ödblink£¡È»ºó
insert into B
SELECT * from A@your_dblink_name;

---

Â¥ÉÏËٶȿÉÒÔ¡£¡£¡£¡£¡£