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: decode(ascii(id_segmento),49,'a','b') or. decode(substring(id_segmento,1,1),'1','a','b') or. decode(instr(id_segmento,'1'),1,'a','b')

Sep 7, 2009 · Oracle 10g has functions that allow the use of POSIX-compliant regular expressions in SQL: REGEXP_LIKE; REGEXP_REPLACE; REGEXP_INSTR; REGEXP_SUBSTR; See the Oracle Database SQL Reference for syntax details on this functions. Take a look at Regular expressions in Perl with examples. Code : select * from tbl where regexp_like(col, '^(ABC|XYZ|PQR)');

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. R_ORG_UNIT_OVER is used to query meta-data on the above unit.

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 REGEXP_LIKE condition in Oracle/PLSQL is: A character expression such as a column or field. It can be a VARCHAR2, CHAR, NVARCHAR2, NCHAR, CLOB or NCLOB data type.

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 illustrates the syntax of the Oracle REGEXP_LIKE() function: REGEXP_LIKE(source_string, search_pattern [, match_parameter]); Code language: SQL (Structured Query ...

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 with the first name of Steven or Stephen: WHERE REGEXP_LIKE((hr.employees.first_name, '^Ste(v|ph)en$') REGEXP_COUNT

6 days ago · 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 Regular Expressions (ERE) standard. Oracle fully supports collating sequences and equivalence classes in bracket expressions .

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 pattern. For example, the following query would return all …

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. Note: This still returns incorrect dates such as 39 Dec 2015.

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 stored in your Oracle database. Here’s a breakdown of the REGEXP_LIKE function and its key components: source_string: The string you want to search.