Results 1 to 3 of 3

Thread: Consolidated View in Oracle

  1. 06-24-2008 #1
    vinayhc
    vinayhc is offline
    Junior Member
    Join Date
    Nov 2007
    Answers
    7

    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

    Reply With Quote Reply With Quote
  2. 06-24-2008 #2
    debasisdas
    debasisdas is offline
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074
    Send a message via ICQ to debasisdas Send a message via AIM to debasisdas Consolidated View in Oracle

    Re: Consolidated View in Oracle

    You need to create a view for the purpose based on join of both the tables

    Reply With Quote Reply With Quote
  3. 06-25-2008 #3
    krishnaindia2007
    krishnaindia2007 is offline
    Expert Member
    Join Date
    Sep 2007
    Answers
    697

    Re: Consolidated View in Oracle

    You can use anti join or minus set operator.

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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

About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
GeekInterview
Interact