Thursday, June 12, 2008

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

No comments:

Post a Comment