Thanks David,

That worked perfectly. It was so simple and I tried it but I did not have tables with same columns and there were additional columns in one select stmt.

Thank...

Hi,

My aim is to see that the three rows match exactly. I am comparing my table to another table in Oracle to see that the entries match. I thought my...

Hi,

I tried using the Join and the Query does take a long time to execute. Will the Cursor work better , as I am doing a row by row comparison...

Text coz thats easy to compare... i have made all the columns as text

In the sheet attatched I have an extract of the data from the database. I have only included the columns I require .

Columns 2 & 3 refer to a same...

When I use a SELECT statement with the JOIN, I get a cartesian join and it shows me all the columns reapeated. I tried using an UPDATE statement and it...

Thanks Mahesh & Jeff

I dont want to have the duplicate rows in the table in my database. I was wondering if I could create a view tat will help me...

Hi Michael,

The problem is solved and I am able to query the Oracle view. Thanks a ton to you.

When creating the linked server the fourth parameter, which is the hostname...

Hi,

Thanks Michael and Jeremy for the responses. The problem is not yet solved.

The Oracle Client is installed on my system and I have also created a dsn named 'Oracle.dsn', I...

Thanks, but I have an error message when I try to execute a query. Any idea what this is???

This is the error message

OLE DB provider "MSDAORA" for linked server "oralink"...