I am constantly having to run queries for a large list of items and I am unable to find an easy way to do it within toad for oracle. In access if I have a list of > 1000 items I will put it in a local temp table and then run my query off of the table, but I have not found a similar solution yet for oracle/toad for oracle.
I thought I would ask the forums to see if any of you have experience this headache and how you resolved it.
Any advice is greatly appreciated!
So, I did some searching and found this post (http://toadfororacle.com/thread.jspa?messageID=123107) that mentioned creating an external table, but I have a question about that as well. What exactly is an external table? If I create an external table will it be local to my machine? Is it external from the database schema that is selected so, essentially a local table?
Any help is appreciated…
Message was edited by: TrentL