using exists against entire column?
I originally wanted to write a select statement that would only pull data if a db element existed in a local directory as a filename. I found this was not an option so I wrote a perl script to store the directory contents into an array and then push the array elements into a new column of the db I am trying to query. All I need to do now is write my select statement to pull rows if the value of column_b exits in my new column that was built by the directory contents array.
This is easy if I was trying to compare the column values while staying on a single row but my issue is that I need to compare the single row value for column_b against ANY row value of column_d
Is this possible?
Subject
Written By
Posted
using exists against entire column?
December 07, 2006 12:59PM
December 07, 2006 01:53PM
December 07, 2006 02:06PM
December 07, 2006 11:01PM
December 09, 2006 04:09PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.