Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jadhavrajesh

  1. jadhavrajesh

    How do I compare multiple records?

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

    How do I compare multiple records?

    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...
  3. jadhavrajesh

    How do I compare multiple records?

    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
  4. jadhavrajesh

    How do I compare multiple records?

    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...
  5. jadhavrajesh

    How do I compare multiple records?

    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
  6. jadhavrajesh

    How do I compare multiple records?

    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...
See more

Part and Inventory Search

Back
Top