<div>
<div class="content wysiwyg-content">
I have two tables which has identical table definition, one table has a few addtional records. &nbsp;I need to see those additional records. &nbsp;The &quot;left join&quot; statement doesn't work in Oracle, and putting (+) in condition column doesn't return the right result for me neither. &nbsp;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 &nbsp; col2 &nbsp; col3 
------------------- 
&nbsp;1 &nbsp; &nbsp; &nbsp; 11 &nbsp; &nbsp; &nbsp; A 
&nbsp;2 &nbsp; &nbsp; &nbsp; 11 &nbsp; &nbsp; &nbsp; B 
&nbsp;3 &nbsp; &nbsp; &nbsp; 12 &nbsp; &nbsp; &nbsp; C 
&nbsp; 
TableB 
------------------- 
col1 &nbsp; col2 &nbsp; col3 
------------------- 
&nbsp;1 &nbsp; &nbsp; &nbsp; 11 &nbsp; &nbsp; &nbsp; A 
&nbsp;2 &nbsp; &nbsp; &nbsp; 11 &nbsp; &nbsp; &nbsp; B 
&nbsp;3 &nbsp; &nbsp; &nbsp; 12 &nbsp; &nbsp; &nbsp; C 
&nbsp;4 &nbsp; &nbsp; &nbsp; 12 &nbsp; &nbsp; &nbsp; D 
 
The results should gives me TableB the last record. &nbsp;Please help. &nbsp;Thanks. 
</div>
</div>

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. 

Oracle 9i PL/SQL outer join two tables

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

A virtual private network (VPN) is a network that uses a public telecommunication infrastructure, such as the Internet, to provide remote offices or travelling users access to a central organizational network securely. VPNs encapsulate data transfers using secure cryptographic methods and other security mechanisms to ensure that only authorized users can access the network and that the data cannot be intercepted.