decode(instr(id_segmento,'1'),0,'b','a') I'm assuming you want to match on a '1' anywhere in the field. If you want to match on fields that start with a '1' then you could use: …

Sep 7, 2009 · Oracle 10g has functions that allow the use of POSIX-compliant regular expressions in SQL: REGEXP_LIKE; REGEXP_REPLACE; REGEXP_INSTR; …

Nov 11, 2016 · I'm trying to use REGEXP_LIKE in conjunction with an ELSEIF inside a loop to run up the tree until I hit the first eligible parent unit. T_STOP is the control variable for the loop. …

The Oracle REGEXP_LIKE condition allows you to perform regular expression matching in the WHERE clause of a SELECT, INSERT, UPDATE, or DELETE statement. The syntax for the …

The REGEXP_LIKE() function returns rows that match a regular expression pattern. Noted that in SQL standard, REGEXP_LIKE is an operator instead of a function. Syntax. The following …

REGEXP_LIKE. Condition that can appear in the WHERE clause of a query, causing the query to return rows that match the given pattern. Example: This WHERE clause identifies employees …

Apr 14, 2025 · With version 10g Release 1, Oracle Database offers 4 regexp functions that you can use in SQL and PL/SQL statements. These functions implement the POSIX Extended …

Here’s a brief overview of the most commonly used Oracle PL/SQL regular expression functions: REGEXP_LIKE : This function checks whether a string matches a given regular expression …

where regexp_like (dt, '[0-9]{4}-[0-9]{2}-[0-9]{2}') 5 rows selected. The dates are supplied as strings and regexp_like validates for the specified pattern. Returns the valid date formats. …

The REGEXP_LIKE function in Oracle PL/SQL is a powerful tool for pattern matching within strings. This function allows you to use regular expressions to search for patterns in text data …