I have schema called SCOTT. In this I have a table Called EMP. The structure of EMP is as follows.
Create table EMP
zip number (8),
i have a view EPM_VW in some other schema SYS which is created on 5 tables having related data to EMP table. Now my requirement is if am doing any modifications like INSERT/Update/Delete or any thing on EMP table in SCOTT it should be effectting immediately on the VIEW. Can you please give me your ideas?