Initially i didn know that sqlldr.exe will be present in the bin folder of the Oracle client:)

Now am able to import files using sqlldr in the windows command prompt..

Yep...got it!

But my other concern was i checked for duplicate values in the file containing the names(using a java program)....but could not find any...

Anyway, i found the culprit:

The java program...

Could...

Chris,

I imported a text file having 250,000 unique names(text has 250000 lines..ie.1 name...

Thanks pal! This served the prupose:)

Hi,

Does using CROSS JOIN affect performance when there more than 100 hundred records in the table?

Or is there any workaround for this ..like indexing or temporary tables?

Hi,

i got this resolved. The problem was due to an invalid statement in the stored procedure...the error did not appear when the stored procedure was compiled..but when called from a...

Thanks Jeff...that code snippet did work...:)

But when my tableA had 6 distinct records and tableB had 7 distinct records...i find that only three values from column2 of tableB were...

I have tried the below query too but get an error message saying that the select query returns more than one result

update dbo.tableA set column1=(select column2 from dbo.tableB where (abs(cast((BINARY_CHECKSUM(column2,NEWID()))...

There need not be a relation between tableA and tableB. Its just that i dont require the values in tableA. The aim is to do a substitution....

The select query in...

Thanks all....The solution really helped in time.