oracle regex

I want to extract text from a column using regular expressions in Oracle 11g. I have 2 queries that do the job but I'm looking for a (cleaner/nicer)…

When I let this Query run in my Oracle SQL Developer 1.5.3 select COLUMNNAME , REPLACE( COLUMNNAME, 'BEFORESTRING', 'AFTERSTRING' ) as COLUMNNAME…

I was looking at replace('ABC-DEF', '-') and regexp_replace('ABC-DEF', '-$') to help me remove all characters after a dash but I haven't been able…

Hi I have a table in Oracle with a VARCHAR column called DESCRIPTION. Some of the rows contain non-printable characters such as the character with…

I have an oracle table with a varchar(100) column, and I need separate rows based on the strings combinations inside that column. The string…

I have a SQL that uses REGEXP_LIKE function in the where clause, now i need the equivalent of that function which will run in Oracle 8i. The regex…

Say I want to allow in a table column only strings that begin with a numeral and should not contain '$' in it. How would a check constraint on this…

Guys , I am using the following oracle sql query to list down the rows for a column that has values other than digits. select * from…

What would be the best way to count occurrences of all non alphanumeric characters that appear in a string in a Oracle database column. When…

I have a column named data_column, it has some value like "123123,12,123123". I want to count rows grouped by the second one. But when i run select…

Hi, I'm using Oracle regural expressions and I want to match some string, then something different to another string and then another string. For…

Would using the wildcard regular expression in a REGEXP_LIKE be less performant than not including the condition clause at all. For example, I want…

hey regex guru's I have a data column that contains a substring similar to this: 'This is a string with ID=123 contained inside' i need to replace…