Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

Consolidated View in Oracle

This is a discussion on Consolidated View in Oracle within the Oracle forums, part of the Databases category; 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 ...

Geeks Talk > Databases > Oracle Consolidated View in Oracle

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   06-24-2008

vinayhc Junior Member   Join Date: Nov 2007 Posts: 11 Thanks: 4 Thanked 1 Time in 1 Post

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

Sponsored Links

#2 (permalink)   06-24-2008

debasisdas Moderator   Join Date: Jun 2007 Location: Bangalore,India Posts: 1,432 Thanks: 8 Thanked 125 Times in 112 Posts

Re: Consolidated View in Oracle You need to create a view for the purpose based on join of both the tables

#3 (permalink)   06-25-2008

krishnaindia2007 Expert Member   Join Date: Sep 2007 Posts: 754 Thanks: 22 Thanked 64 Times in 63 Posts

Re: Consolidated View in Oracle You can use anti join or minus set operator.

Geeks Talk > Databases > Oracle

« Application Server & Database Server | Explain Plan »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Normal View, Materialised View and Bitmap Index	Geek_Guest	Oracle	3	05-28-2008 12:59 AM
view	jayanth511	SQL	4	04-17-2008 05:45 PM
View	krishnaindia2007	Oracle	6	02-19-2008 01:49 PM
What will be there in Keyword view and Expert View?	suneetham	QTP	1	02-07-2008 08:14 AM
2 Universe consolidated to one global universe	Geek_Guest	Data Warehousing	1	04-03-2007 11:05 AM

All times are GMT -4. The time now is 02:46 AM.