12 Replies Latest reply on Jan 25, 2013 8:06 AM by avish16

    SQL -Condition required solution

    Anbarasan-Oracle
      Hi

      i have table T_MAK
      --------------------------------------------------
      NAME GROUP
      Raj MKTDEV:MKTING
      arun MKTDEV
      anil MKTING
      king PRODE
      ------------------------------------------------------------
      I am trying to filter like
      SELECT NAME FROM T_MAK WHERE GROUP LIKE OR IN (MKTDEV:MKTING)..then this both contains name should display
      final out put like
      -----------
      NAME
      Raj
      arun
      anil
      --------------
      Please help out the query..