You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for REGEXP_LIKE


1 to 20 of 298 results. Previous page Prev  Next next page
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 command … ends with a number. select problem_id, problem_key from problem \\ where regexp_like(problem_key, '[0-9]$') = true Parent

Database Utilities, Release 18c

ADRCI: ADR Command Interpreter

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 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

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

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 PL/SQL Language Reference, Release 19c

PL/SQL Static SQL

6.2.2.3 Fetching Data with Explicit CursorsInside LOOP Statements DECLARE CURSOR c1 IS SELECT last_name, job_id FROM employees WHERE REGEXP_LIKE … WHERE REGEXP_LIKE (job_id, '[ACADFIMKSA]_M[ANGR]') ORDER BY job_id; v_employees employees%ROWTYPE