select 'red', 'green', 'blue' from dual I'm wondering if that will work for you, just as a subquery for your join..
Ian Skinner wrote: >Are there any Oracle knowledgeable people online today? > >What is the easiest way to create a temporary view or table to contain a list >of values that I currently have in a ColdFusion variable? > >In other words, how can I turn a list like this: <cfset aList = >"Red,Green,Blue"> into a temporary view or table so that I can outer join the >list to another table in the database to get a record set that contains a row >for every value in the list, whether or not there is a coresponding value in >the second table? > >Thank You > >-------------- >Ian Skinner >Web Programmer >BloodSource >www.BloodSource.org >Sacramento, CA > >"C code. C code run. Run code run. Please!" >- Cynthia Dunning > >Confidentiality Notice: This message including any >attachments is for the sole use of the intended >recipient(s) and may contain confidential and privileged >information. Any unauthorized review, use, disclosure or >distribution is prohibited. If you are not the >intended recipient, please contact the sender and >delete any copies of this message. > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229687 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
