Home » SQL & PL/SQL » SQL & PL/SQL » How to get value from Exel sheet ang make a query in the Datebank
How to get value from Exel sheet ang make a query in the Datebank [message #206912] Sat, 02 December 2006 04:04
gdeba001
Messages: 1
Registered: December 2006
Junior Member
Hello,

I have the folowwing Exel Sheet.

COF_CODE VC_LEGAL_ID filter score
121B0KXR3 3 0 562
121B0PVT3 6 0 572
121364748 3 0 558
121B0S2V9 3 0 552
121273093 6 0 561
121010454 6 0 552
121599707 3 0 561
121B0XQF4 3 0 569
121598981 3 0 560

I want to get the COF_CODE make a query in the datenbank and to find the ABN_ORG_ZN_NR and put the result in a new excel or text file


select r.ABN_ORG_ZN_NR
from cok_risiken r
where r.coface_r_nr = COF_CODE

The Result can be like the following

COF_CODE ABN_ORG_ZN_NR VC_LEGAL_ID filter score
121B0KXR3 ??? 3 0 562
121B0PVT3 ??? 6 0 572
121364748 ??? 3 0 558
121B0S2V9 ??? 3 0 552
121273093 ??? 6 0 561
121010454 ??? 6 0 552
121599707 ??? 3 0 561
121B0XQF4 ??? 3 0 569
121598981 ??? 3 0 560


OK many thanks for your help
  • Attachment: info.xls
    (Size: 135.50KB, Downloaded 495 times)

[Updated on: Sat, 02 December 2006 05:55]

Report message to a moderator

Previous Topic: LEFT OUTER JOIN
Next Topic: An error on a package .....
Goto Forum:
  


Current Time: Sat Dec 10 06:41:10 CST 2016

Total time taken to generate the page: 0.08210 seconds