摘要： CREATE PUBLIC DATABASE LINK testlinkCONNECT TO hxka IDENTIFIED BY bjdscoalUSING '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.0.188)(PORT = 1520)))(CONNECT_DATA =(SID = expired)))';例如： CREATE PUBLIC DATABASE LINK MYDBLINKCONNECT TO USER1 IDENTIFIED BY PASSWORD1USING 阅读全文

摘要： orcle插入新数据 values 为查询语句。insert into userinfo(id,name) values((select nvl(max(id),0) from userinfo),'dd' ) 阅读全文