Timeline for How can I show the values from my input that don't exist in a table?
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 6, 2017 at 7:48 | comment | added | WashichawbachaW |
I'm running my query on Oracle SQL Developer (3.2.09). Yes! I need to check all of them in one query because every value or order_number is part of one file e.g. file_A = 1000 order_numbers. So if I find like 100 missing order_numbers out of 1000 then I'll report it like, In file_A there are 100 missing order_numbers and I will also include the missing order_umbers in my report. By the way, can we move this convo to chat?
|
|
| Oct 6, 2017 at 7:24 | comment | added | Andriy M | On the other hand, why are there so many values to check? Do you need to check all of them in one query? Also, where do they come from? If they are already in some table, perhaps you could use it in an anti-join using any of the patterns in my answer? | |
| Oct 6, 2017 at 7:22 | comment | added | Andriy M |
Other database products support the VALUES table constructor syntax, like VALUES ('value1'), ('value2'), ('value3), … which allows you to create a table in a syntactically more compact way. I'm not sure if the latest release of Oracle DB supports it. And if it doesn't, I have no other ideas at the moment, sorry.
|
|
| Oct 5, 2017 at 23:34 | comment | added | WashichawbachaW |
Thank you for your answer, however, I'm doing like thousands of thousands of values every query. Imagine If I do that SELECT 'value' AS ordernumber FROM DUAL a thousand times? It's really a pain in the ass right? Is there any other solution like putting all the values in one group like ('value1','value2','value3','value4',......)?
|
|
| Oct 5, 2017 at 9:08 | history | answered | Andriy M | CC BY-SA 3.0 |