How to compare two tables data without using join.
Hi friends,
There are two tables which are having 40 columns each(tables
structure is same except one table is having char columns &
other is varchar2),some corresponding columns data is same, i
want to retrieve the data when there is a match for the columns
without using join conditions( Since 40 columns, a big join will
be there). Any Oracle function which will take Table names as
arguments and compares the data..?. Please give your suggestions
or Queries..
Regards,
G. Rajakumar.