Filter Spaces in Oracle with Regex

1 year ago
Sophia Anderson
1 minute

To filter spaces using Oracle regular expressions, you can utilize the REGEXP_REPLACE function. This function can search for and replace characters that match the regular expression in a string.

Here is an example of using REGEXP_REPLACE to filter spaces:

SELECT REGEXP_REPLACE('Hello World', ' ', '') AS result FROM dual;

The output is “HelloWorld” with the spaces filtered out.

In regular expressions, spaces can be represented by `\s`. Therefore, to filter out all spaces, you can use the following code:

SELECT REGEXP_REPLACE('Hello World', '\s', '') AS result FROM dual;

The output will also be: HelloWorld.

bannerAds