The best place to *find* answers to programming/development questions, imo, however it's the *worst* place to *ask* questions (if your first question/comment doesn't get any up-rating/response, then u can't ask anymore questions--ridiculously unrealistic), but again, a great reference for *finding* answers.

My Music (Nickleus)

20130404

oracle sql - how to select column with string containing underscore _

underscore ( _ ) is a wildcard in oracle sql, so to get results of a row with a column containing a string with a literal underscore "wildcard" in it:
X_AGR_234253

you need to escape the underscore with a backslash ( \ ):
select * from my_table where my_column like 'X\_AGR%'

the underscore in an "sql select like" statement is like the regex period/full-stop wildcard ( . )

thanks to don:
http://www.dba-oracle.com/t_special_characters_like_sql_query.htm

No comments:

Post a Comment