First off, I’m new here, and I did search to see if someone has asked this question before, but I didn’t find any - so if I missed it, I am sorry.
I just started using Toad the other day after discovering my company had a license - but no one had thought to tell us - go figure.
I’ve been trying to figure out how to do something for a while now, and I’m wondering if Toad can help me.
I have a table in an Oracle database where there is a need to be able to match a value across multiple columns, each of which is capable of storing the same value. I know this probably isn’t the best implementation, but it’s not changeable.
Previously the only way I’ve been able to locate records with a specific value in one of these 20 columns has been my running my query 20 separate times, just changing the field name each time - with Toad, I realize I could automate that task, but that’s still not ideal.
So my question is this - is there anyway to build a query in such a way that I can supply the value that I’m looking for, and it will attempt to match it across this range of 20 possible locations within the record?
I apologize if this question is somewhat confusing; I’ll be happy to clarify if needed.