Find Underscores in an Alphabetic Field

To find an underscore in a name, it must be 'escaped.' In this case, I'm using a backslash, but it can be other characters as well.

Select Table_Name
  From All_Tables
 Where Table_Name Like '%\_%' Escape '\'
   And Rownum <>

See Oracle documentation for further detail:
Like & Escape