Solved

Oracle 9i PL/SQL outer join two tables

Posted on 2010-09-12
2
590 Views
Last Modified: 2013-12-19
I have two tables which has identical table definition, one table has a few addtional records.  I need to see those additional records.  The "left join" statement doesn't work in Oracle, and putting (+) in condition column doesn't return the right result for me neither.  They have quite a few columns as well, so if there is a way I don't need to type all the columns name in will be even better.

e.g.
TableA
-------------------
col1   col2   col3
-------------------
 1       11       A
 2       11       B
 3       12       C
 
TableB
-------------------
col1   col2   col3
-------------------
 1       11       A
 2       11       B
 3       12       C
 4       12       D

The results should gives me TableB the last record.  Please help.  Thanks.
0
Comment
Question by:cmleung2
2 Comments
 
LVL 74

Accepted Solution

by:
sdstuber earned 500 total points
ID: 33656740
so, you only want

4   12   D  to be returned?

if so, try this...

select * from tableB
minus
select * from tableA
0
 
LVL 1

Author Closing Comment

by:cmleung2
ID: 33656797
That works.  Thanks.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Let’s list some of the technologies that enable smooth teleworking. 
This video shows how to recover a database from a user managed backup
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question