-
Junior Member
Consolidated View in Oracle
Hi all,
I want to create a consolidated view in Oracle which provides data from two tables.
If the data is present in table A then it should not be fetched from table B.
this is the only criteria.
Please could you suggest a way forward.
Thanks
Vinay
-
Re: Consolidated View in Oracle
You need to create a view for the purpose based on join of both the tables
-
Expert Member
Re: Consolidated View in Oracle
You can use anti join or minus set operator.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules