create  PUBLIC database link bjlink

CONNECT TO username IDENTIFIED BY password

using '(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xx.xx)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = xxx)

)

)'

update   student  

  set   student.name   =   student1.name,  

          student.id   =   student1.id  

  (select   student1.name,student1.id  

  from   student,student1  

  where   student.int_id   =   student1.int_id);  

update   student   set   (name,id   )=  

  (select   name   ,id     from   (select   student.rowid   rd,student1.name,student1.id   from   student1,student   where   student1.int_id   =student.int_id)   tmp  

  where   student.rowid=tmp.rd);  

  commit;

SQL：

update inventory set prod_id=

(

select prod_id from inventory_temp where inventory_temp.lot_no=inventory.lot_no

)

where