Shell Programming and Scripting

Hi All ,

Please find my query below

I have to compare excel column value with column value in oracle table .
So can you please tell me how to store the value of an excel column in variable and check whether this value exist in particular table or not

Thanks for your kind help

I think this query would be better suited to a windows/excel/odbc forum.

But in the event you are saving the excel file as a CSV or tab separated file, can you give us a sample of the input file and what have you done thus far to query the oracle database -- please remember to obscure the username and password you used in your connection string.

Hi ,
Actually i tried to take the file column value with awk in a array variable and then try to compare with these values with the rows in table in oracle

Please check my input excel file

Code:

Id                       Value
1                         ABC
2                         DEF
3                         XYZ
4                         PQR

Now I have to check whether ID column values are present in certain oracle table column or not

Is it possible to go by my approach
Can we pass unix variable value in sql query

Any suggestion will help me a lot ...Thnx

Moderator's Comments:

Please use code tags when posting data and code samples!

If you were hand-coding the query ... what would it look like?

Hi Ludwig,

So far I have not tried yet ,I just want to make sure from you gurus whether it is at all possible to take the column values in a unix variable and check this values whether they exist in some table or not

You can use the SQL Loader utility to load the data in a the database and compare the data with SQL.
You may have a read of:

SQL*Loader FAQ - Oracle FAQ

Hi Franklin

thnx for your suggestion , I had consider that earlier .
but isnt there any way to pass unix variable to sql query if thats possible then I can easily search whether the details exist in the table or not