Results for REGEXP_LIKE


1 to 20 of 301 results. Prev  Next
Results per page:   20  | 40 | 60


SQL Language Reference, Release 19c

Pattern-matching Conditions

REGEXP_LIKE ConditionREGEXP_LIKE is similar to the LIKE condition, except REGEXP_LIKE performs regular expression … the REGEXP_LIKE condition. A period (.) does not match the newline character. The source string is … treated as a single line. Similar to the LIKE condition, the REGEXP_LIKE condition is collation … collation determination

SQL Language Reference, Release 18c

Pattern-matching Conditions

REGEXP_LIKE ConditionREGEXP_LIKE is similar to the LIKE condition, except REGEXP_LIKE performs regular expression … the REGEXP_LIKE condition. A period (.) does not match the newline character. The source string is … treated as a single line. Similar to the LIKE condition, the REGEXP_LIKE condition is collation … collation determination

Database Utilities, Release 19c

ADRCI: ADR Command Interpreter

19.9.9.9 REGEXP_LIKE, REGEXP_LIKE is a condition instead of a function. Syntax See Oracle Database SQL Language Reference … . Restrictions The following restrictions apply when you use the REGEXP_LIKE function in the SELECT … ends with a number. select problem_id, problem_key from problem \\ where regexp_like(problem_key, '[0-9]$') = true Parent topic:

Database Utilities, Release 18c

ADRCI: ADR Command Interpreter

19.9.9.9 REGEXP_LIKE, REGEXP_LIKE is a condition instead of a function. Syntax See Oracle Database SQL Language Reference … . Restrictions The following restrictions apply when you use the REGEXP_LIKE function in the SELECT command … ends with a number. select problem_id, problem_key from problem \\ where regexp_like(problem_key, '[0-9]$') = true Parent

SQL Language Reference, Release 12.2

Pattern-matching Conditions

6.7.2 REGEXP_LIKE Conditionis blank-padded to 6 bytes. v is not blank-padded and has length 4. 6.7.2 REGEXP_LIKE Condition … REGEXP_LIKE is similar to the LIKE condition, except REGEXP_LIKE performs regular expression matching … REGEXP_LIKE condition. A period (.) does not match the newline character. The source string is treated … as a

Database SQL Language Reference, 11g Release 1 (11.1)

Pattern-matching Conditions

REGEXP_LIKE ConditionREGEXP_LIKE is similar to the LIKE condition, except REGEXP_LIKE performs regular expression … , last_name FROM employees WHERE REGEXP_LIKE (first_name, '^Ste(v|ph)en$') ORDER BY first_name, last_name … case): SELECT last_name FROM employees WHERE REGEXP_LIKE (last_name, '([aeiou])\\1', 'i') ORDER BY

Database SQL Language Reference, 12c Release 1 (12.1)

Pattern-matching Conditions

REGEXP_LIKE ConditionREGEXP_LIKE is similar to the LIKE condition, except REGEXP_LIKE performs regular expression … , last_name FROM employees WHERE REGEXP_LIKE (first_name, '^Ste(v|ph)en$') ORDER BY first_name … , regardless of case): SELECT last_name FROM employees WHERE REGEXP_LIKE (last_name, '([aeiou])\\1', 'i

Database SQL Language Reference, 11g Release 2 (11.2)

Pattern-matching Conditions

REGEXP_LIKE ConditionREGEXP_LIKE is similar to the LIKE condition, except REGEXP_LIKE performs regular expression … , last_name FROM employees WHERE REGEXP_LIKE (first_name, '^Ste(v|ph)en$') ORDER BY first_name … , regardless of case): SELECT last_name FROM employees WHERE REGEXP_LIKE (last_name, '([aeiou])\\1', 'i

Database SQL Language Reference

Pattern-matching Conditions

REGEXP_LIKE ConditionREGEXP_LIKE is similar to the LIKE condition, except REGEXP_LIKE performs regular expression … the REGEXP_LIKE condition. A period (.) does not match the newline character. The source string is … treated as a single line. Similar to the LIKE condition, the REGEXP_LIKE condition is collation … collation determination

Database Utilities, 12c Release 1 (12.1)

REGEXP_LIKE

REGEXP_LIKE, REGEXP_LIKE is a condition instead of a function. Syntax See Oracle Database SQL Language Reference … . Restrictions The following restrictions apply when you use the REGEXP_LIKE function in the SELECT command … ends with a number. select problem_id, problem_key from problem \\ where regexp_like(problem_key, '[0-9]$') = true

SQL Reference, 10g Release 1 (10.1)

REGEXP_LIKE

REGEXP_LIKEis similar to the LIKE condition, except REGEXP_LIKE performs regular expression matching instead … employees WHERE REGEXP_LIKE (first_name, '^Ste(v|ph)en$'); FIRST_NAME LAST_NAME … WHERE REGEXP_LIKE (last_name, '([aeiou])\1', 'i'); LAST_NAME ------------------------- De Haan Greenberg Khoo Gee Greene Lee Bloom Feeney

Database Utilities, Release 12.2

ADRCI: ADR Command Interpreter

19.9.9.9 REGEXP_LIKE, REGEXP_LIKE is a condition instead of a function. Syntax See Oracle Database SQL Language Reference … . Restrictions The following restrictions apply when you use the REGEXP_LIKE function in the SELECT command … ends with a number. select problem_id, problem_key from problem \\ where regexp_like(problem_key, '[0-9]$') = true Parent

Database PL/SQL Language Reference, Release 19c

PL/SQL Optimization and Tuning

12.3.6 Use SQL Character Functionscharacter functions that return number values Example 6-6 for an example of PL/SQL code that uses SQL character function REGEXP_LIKE

MySQL, Release 5.5

Appendix D Indexes

REGEXP_LIKE(), Regular Expression Functions and OperatorsREGEXP_REPLACE(), Regular Expression Functions and Operators

Database PL/SQL Language Reference, Release 19c

PL/SQL Static SQL

6.4.3 Fetching Data with Cursor Variables; -- variable for job_id query_2 VARCHAR2(200):= 'SELECT * FROM employees WHERE REGEXP_LIKE (job_id … BEGIN OPEN cv FOR SELECT last_name, job_id FROM employees WHERE REGEXP_LIKE (job_id, 'S[HT]_CLERK

SQL Language Reference, Release 19c

REGEXP_INSTR

REGEXP_INSTRREGEXP_SUBSTR REGEXP_REPLACE and REGEXP_LIKE Condition Appendix C in Oracle Database Globalization

SQL Language Reference, Release 19c

REGEXP_SUBSTR

REGEXP_SUBSTRREGEXP_REPLACE, and REGEXP_LIKE Condition Appendix C in Oracle Database Globalization Support Guide for

Database PL/SQL Language Reference, Release 19c

PL/SQL Language Fundamentals

2.7.5.3 LIKE OperatorREGEXP_LIKE, which is similar to LIKE Example 2-44 LIKE Operator in Expression The string 'Johnson' matches

SQL Language Reference, Release 19c

REGEXP_REPLACE

Column 1 contains regular expression operators and column 2 describes Oracle Database support of each…detailed information. See Also: REPLACE REGEXP_INSTR, REGEXP_SUBSTR, and REGEXP_LIKE Condition Appendix C

Database SQL Reference, 10g Release 2 (10.2)

Pattern-matching Conditions

REGEXP_LIKE ConditionREGEXP_LIKE is similar to the LIKE condition, except REGEXP_LIKE performs regular expression … FROM employees WHERE REGEXP_LIKE (first_name, '^Ste(v|ph)en$'); FIRST_NAME LAST_NAME … employees WHERE REGEXP_LIKE (last_name, '([aeiou])\\1', 'i'); LAST_NAME ------------------------- De Haan Greenberg Khoo Gee Greene Lee





Was this page helpful?

Integrated Cloud Applications & Platform Services