How to use If loop in Oracle SQL views?

Question

I have a 3 different tables and in that I have 4 common cols. I want to create view which select all 3 tables when I perform DML operation for either one or all tables, it should show updated data for modified and last changes data for non-modified records.

Answer 1

Saravanan this answer from stack overflow might help https://stackoverflow.com/questions/13151393/joining-in-sql-on-more-than-2-tables-using-oracle

View can be looked at as a temporary table and it will automatically update itself when the table associated with it are updated.

Answer 2

Oracle SQL.

Answer 3

𝐊𝐢𝐢𝐛𝐨 𝐆𝐡𝐚𝐲𝐚𝐥 just read the description

Answer 4

Avinesh thanks for your update and The Scenario is mentioned in description.