This discussion is archived
2 Replies Latest reply: Oct 14, 2012 12:42 AM by Venkadesh Raja RSS

Help write query

967898 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    Can you Pls Explain your question little more clear ?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points