This content has been marked as final. Show 3 replies
4. But when I update:Use the following :
SQL> update SALARY set pay=1000 where employee_id=101; --> OK
SQL> commit; --> OK
But when I select the pay of employee_id 101, it is not updated.
(the same scenario happens in PROD2 when i try to update EMPLOYEES)
update SALARY@PROD2_LNK set pay=1000 where employee_id=101
Since you are not using the database link 'PROD2_LNK', the salary table in PROD1 db is getting updated and hence facing the issue.
Please use the db link it will solve your purpose.
Edited by: Vedant.. on Dec 4, 2012 10:51 AM