Copy table

select rowid, tsirms217400.* from tsirms217400

select * from tsirms203400

insert into TSIRMS217400 (BCODE, LOTNO, QUANTITY,TIME_STAT, USRNAME,
STATUS, TIME_UPD)
select BCODE, LOTNO, QUANTITY, TIME_STAMP, 'MMD', '1', sysdate
from tsirms203400
where rowid='AAAzHVAAhAAAFiRAAA'