2 Replies Latest reply: Oct 14, 2012 2:42 AM by Venkadesh Raja RSS

    Help write query

    967898
      I have a table something as below

      Things_t
      Things     Characteristic     Char Value
      Item 1     Colour     Red
      Item 1     Packaging     
      Item 2     Shape     Square
      Item 2     Brand     Spunk

      Now i want to reterive an item with none of its char values as Null. Using the query “ select distinct things from things_t where char value is Null ” will fetch the item 1 also together with item 2. i want to fetch a record from thing for which none of the char values are Null such as Item 2. Can you please help me with this query.
        • 1. Re: Help write query
          Prabodh
          Welcome to Oracle Forums!
          Please acquaint yourself with the FAQ and forum etiquette if you haven't already done so.
          I have a table something as below
          Things_t
          Things Characteristic Char Value
          Item 1 Colour Red
          Item 1 Packaging
          Item 2 Shape Square
          Item 2 Brand Spunk

          Now i want to reterive an item with none of its char values as Null. Using the query “ select distinct things from things_t where char value is Null ” will fetch the item 1 also together with item 2. i want to fetch a record from thing for which none of the char values are Null such as Item 2. Can you please help me with this query.>

          You query belongs here {forum:id=75}

          Cheers,
          • 2. Re: Help write query
            Venkadesh Raja
            Can you Pls Explain your question little more clear ?