Search results for query: *

Great. That is exactly what I was looking for. Thanks a lot, Rajesh

No problem. I am still designing/developing the application, so I can make all these 3 things happen. I saw this link at Oracle.com http://www.oracle.com/technology/oramag/code/tips2004/050304.html that I was thinking of using to create a view and then query against that. Let me know your...

I will be calling this from JDBC, so most likely I will be calling a PL/SQL if simple SQL is not possible. Thanks, Rajesh

Hi Mufasa, Thank you for looking into this. If I query this table for an array of rule IDs that do not match, then I do not want to display any records. e.g. if I pass 1,2,3,4 as set of my rule_ids, there is no ATT (attribute) that has records matching all the rules. Another example is, if I...

Hi, Sorry I messed up the data, here is the correct version, RULE_ID ATT ---------- ---------- 1 test1 2 test1 3 test1 1 test2 2 test2 Regards, Rajesh

Hi, I have a table that looks like, RULE_ID ATT ---------- ---------- 1 test1 2 test1 1 test1 2 test2 3 test2 Is it possible to write a query like, select ATT from table where RULE_ID "matches all" ( 1,2,3) Here...