4 Replies Latest reply on Dec 12, 2013 9:52 AM by BluShadow

    Oracle SQL query for getting specific special characters from a table

    8ddb6b58-1e92-4a3a-9eb2-d1dc0ca529a8

      Hi all,

      This is my table

      Table Name- Table1

      S.no    Name

      ------     --------------------

      1          aaaaaaaa

      2          a1234sgjghb

      3          a@3$%jkhkjn

      4          abcd-dfghjik

      5          bbvxzckvbzxcv&^%#

      6          ashgweqfg/gfjwgefj////

      7          sdsaf$([]:'

      8          <-fdsjgbdfsg

      9           dfgfdgfd"uodf

      10         aaaa  bbbbz#$

      11         cccc dddd-/mnm

       

      The output has to be

       

      S.no    Name

      ------     --------------------

      3          a@3$%jkhkjn

      5          bbvxzckvbzxcv&^%#

      7          sdsaf$([]:'

      8          <-fdsjgbdfsg

      10         aaaa  bbbbz#$

       

      It has to return "Name" column which is having special characters,whereas some special chars like -, / ," and space are acceptable.

      The Oracle query has to print columns having special characters excluding -,/," and space

      Can anyone help me to get a SQL query for the above.

       

      Thanks in advance.