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 40 of 299 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 … 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

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

Database PL/SQL Language Reference, Release 18c

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

Automatic Storage Management Administrator's Guide, Release 19c

Using Views to Display Oracle ACFS Information

Oracle ACFS Support for Oracle Database File Mapping ViewsFROM V$MAP_FILE WHERE REGEXP_LIKE(FILE_NAME, '*users01.dbf'); FILE_NAME FILE_MAP_IDX FILE_TYPE

SQL Language Reference, Release 19c

Table of Contents

Table of ContentsMEMBER Condition SUBMULTISET Condition Pattern-matching Conditions LIKE Condition REGEXP_LIKE Condition

Database Development Guide, Release 19c

Using Continuous Query Notification (CQN)

Queries that Can Be Registered for QRCN Only in Best-Effort ModeTRUNC, ABS, and SQRT ) Pattern-matching conditions LIKE and REGEXP_LIKE EXISTS or NOT EXISTS

SecureFiles and Large Objects Developer's Guide, Release 19c

SQL Semantics and LOBs

CLOBs and NCLOBs Do Not Follow Session Collation Settingsand NVARCHAR2 values. REGEXP_LIKE REGEXP_REPLACE REGEXP_INSTR REGEXP_SUBSTR REGEXP_COUNT Note

SQL Language Reference, Release 19c

Oracle Support for Optional Features of SQL/Foundation

Table C-2 Oracle Support for Optional Features of SQL/Foundationpredicate Oracle's equivalent is REGEXP_LIKE. Oracle's pattern syntax lacks some of the features of the … REGEXP_LIKE for pattern matching with a Perl-like syntax. T172, AS subquery clause in table definition

Database PL/SQL Language Reference, Release 18c

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

REGEXP_SUBSTR

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

SQL Language Reference, Release 18c

REGEXP_INSTR

REGEXP_INSTRREGEXP_SUBSTR REGEXP_REPLACE and REGEXP_LIKE Condition Appendix C in Oracle Database Globalization

Database PL/SQL Language Reference, Release 18c

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 Development Guide, Release 19c

Using Regular Expressions in Database Applications

Using a Constraint to Enforce a Phone Number Format( l_name VARCHAR2(30), p_number VARCHAR2(30) CONSTRAINT c_contacts_pnf CHECK (REGEXP_LIKE (p_number

SQL Language Reference, Release 18c

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

SQL Language Quick Reference, Release 19c

SQL Conditions

Syntax for SQL Condition Types[ NOT ] NULL REGEXP_LIKE condition REGEXP_LIKE(source_char, pattern [, match_param ] ) Simple comparison

Database PL/SQL Language Reference, Release 18c

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

Database Development Guide, Release 19c

Using Regular Expressions in Database Applications

Oracle SQL Support for Regular ExpressionsName Description REGEXP_LIKE Condition that can appear in the WHERE clause of a query, causing the … the first name of Steven or Stephen: WHERE REGEXP_LIKE((hr.employees.first_name, '^Ste(v|ph)en

Automatic Storage Management Administrator's Guide, Release 18c

Using Views to Display Oracle ACFS Information

Oracle ACFS Support for Oracle Database File Mapping ViewsFROM V$MAP_FILE WHERE REGEXP_LIKE(FILE_NAME, '*users01.dbf'); FILE_NAME FILE_MAP_IDX FILE_TYPE

Java API Reference for Oracle Extension SDK, 12c (12.2.1.3.0)

Comparison.Comparator (Oracle Fusion Middleware Java API Reference for Oracle Extension SDK)

Enum Comparison.Comparator  NOT_EQUAL_ANY   NOT_EQUAL_SOME   NOT_EXISTS   NOT_JSON   NOT_LIKE   NOT_NULL   NULL   REGEXP_LIKEREGEXP_LIKE public static final Comparison.Comparator REGEXP_LIKE EXISTS public static final

JDeveloper, 12c (12.2.1.3.0)

Comparison.Comparator (Oracle Fusion Middleware Java API Reference for Oracle Extension SDK)

Enum Comparison.Comparator  NOT_EQUAL_ANY   NOT_EQUAL_SOME   NOT_EXISTS   NOT_JSON   NOT_LIKE   NOT_NULL   NULL   REGEXP_LIKEREGEXP_LIKE public static final Comparison.Comparator REGEXP_LIKE EXISTS public static final

Database Globalization Support Guide, Release 19c

Linguistic Sorting and Matching

5.9.5 Examples: Regular ExpressionsREGEXP_LIKE(col,'catalog(ue)?'); Example 5-17 Case Insensitivity Overridden by the Run-time Match Option … > SELECT col FROM test WHERE REGEXP_LIKE(col,'catalog(ue)?','c'); Example 5-18 Matching with the Collation … Does not match: cab Oracle Database SQL syntax: SQL> SELECT col FROM test WHERE REGEXP_LIKE(col … >mòbile>pájaro>zurück

SQL Language Reference, Release 18c

Table of Contents

Table of ContentsCondition SUBMULTISET Condition Pattern-matching Conditions LIKE Condition REGEXP_LIKE Condition Null