Inserting / Updating Oracle table...

[allavivek]

Hi All,

A doubt came accross my mind ..

Can we update/insert same table at a time in a job using different links..

Like below..database is oracle..


...............transfromer--------------TABLE(insert)
|
TABLE(insert)

and what about locking mechanism of table when used??

Thank you...

[keshav0307]

yes if you can make sure that you are not updating the same record, you are inserting from other link.