Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Return numeric only rows

User_YJ8XXSep 22 2020 — edited Sep 23 2020
Hi all, I am using OAC with some location data and want to return rows that only have a numeric string. I am finding that I have several instances where the City field only contains a short numeric string so I would like to find those and see if i can identify a pattern. I have been trying to create an expression filter using the City field and the LIKE expression with several variations of '%[0-9]%' but I'm not returning any values. Any suggestions?
Comments
Post Details
Added on Sep 22 2020
5 comments
2,986 views