Results for REGEXP_LIKE


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


SQL Language Reference, Release 20c

Pattern-matching Conditions

REGEXP_LIKE ConditionREGEXP_LIKE is similar to the LIKE condition, except REGEXP_LIKE performs regular expression … 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-sensitive … determination

SQL Language Reference, Release 19c

Pattern-matching Conditions

REGEXP_LIKE ConditionREGEXP_LIKE is similar to the LIKE condition, except REGEXP_LIKE performs regular expression … 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-sensitive … determination

Database Utilities, Release 20c

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:

SQL Language Reference, Release 12.2

Pattern-matching Conditions

REGEXP_LIKE ConditionREGEXP_LIKE is similar to the LIKE condition, except REGEXP_LIKE performs regular expression … 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-sensitive … 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 … 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-sensitive … 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 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, 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 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 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 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

Database PL/SQL Language Reference, Release 20c

PL/SQL Optimization and Tuning

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

MySQL, Release 5.5

Appendix C Indexes

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

Database PL/SQL Language Reference, Release 20c

PL/SQL Static SQL

7.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 20c

REGEXP_SUBSTR

REGEXP_SUBSTR… See Also: SUBSTR and REGEXP_INSTR REGEXP_REPLACE, and REGEXP_LIKE Condition Appendix C in Oracle

SQL Language Reference, Release 20c

REGEXP_INSTR

REGEXP_INSTRsubexpr is zero. See Also: INSTR and REGEXP_SUBSTR REGEXP_REPLACE and REGEXP_LIKE Condition Appendix C

Database PL/SQL Language Reference, Release 20c

PL/SQL Language Fundamentals

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

SQL Language Reference, Release 20c

REGEXP_REPLACE

Column 1 contains regular expression operators and column 2 describes Oracle Database support of each…, and REGEXP_LIKE Condition Appendix C in Oracle Database Globalization Support Guide for the

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

Database PL/SQL Language Reference, Release 20c

PL/SQL Static SQL

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

SQL Language Reference, Release 20c

Table of Contents

Table of ContentsConditions LIKE Condition REGEXP_LIKE Condition Null Conditions XML Conditions EQUALS_PATH Condition

Database Development Guide, Release 20c

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

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

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

REGEXP_SUBSTR… See Also: SUBSTR and REGEXP_INSTR REGEXP_REPLACE, and REGEXP_LIKE Condition Appendix C in Oracle

SQL Language Reference, Release 19c

REGEXP_INSTR

REGEXP_INSTRsubexpr is zero. See Also: INSTR and REGEXP_SUBSTR REGEXP_REPLACE and REGEXP_LIKE Condition Appendix C

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

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

REGEXP_REPLACE

Column 1 contains regular expression operators and column 2 describes Oracle Database support of each…, and REGEXP_LIKE Condition Appendix C in Oracle Database Globalization Support Guide for the

SQL Language Quick Reference, Release 20c

SQL Conditions

Syntax for SQL Condition Types] nested_table Null conditions expr IS [ NOT ] NULL REGEXP_LIKE condition REGEXP_LIKE(source_char, pattern

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

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

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

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

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

Table of Contents

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

JDeveloper, 12c (12.2.1.3.0)

Uses of Class oracle.javatools.db.sql.Comparison.Comparator (Oracle Fusion Middleware Java API Reference for Oracle Extension SDK)

Uses of Class oracle.javatools.db.sql.Comparison.Comparatorfragment for regexp_like, which has function format. Comparison ( SQLFragment  left, Comparison.Comparator

JDeveloper, 12c (12.2.1.3.0)

Uses of Class oracle.javatools.db.sql.Comparison.Comparator (Oracle Fusion Middleware Java API Reference for Oracle Extension SDK)

Uses of Class oracle.javatools.db.sql.Comparison.Comparatorfragment for regexp_like, which has function format. Comparison ( SQLFragment  left, Comparison.Comparator

Spatial and Graph Property Graph Developer's Guide, Release 20c

SQL-Based Property Graph Query and Analytics

4.1 Simple Property Graph Queriesthe connections graph. SQL> select vid, t, k, v from connectionsVT$ where t=1 and regexp_like(v … (INTERNAL_FUNCTION(\"V\") AND REGEXP_LIKE (\"V\",U'([aeiou])\\005C1','i') AND \"T\"=1 AND INTERNAL_FUNCTION(\"K … - filter(INTERNAL_FUNCTION(\"V\") AND REGEXP_LIKE (\"V\",U'([aeiou])\\005C1','i') AND \"T\"=1 AND

JDeveloper, 12c (12.2.1.2.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 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

Fusion Middleware Solutions Guide for Oracle TopLink, 12c (12.2.1.3.0)

Using Oracle TopLink with the Oracle Database

24.2.1 Using Oracle Platform-Specific APIs) Returning clause Custom expression functions ( REGEXP_LIKE, LOCATE, ATAN2, LOG, CONCAT, SYSDATE (Date

Fusion Middleware Solutions Guide for Oracle TopLink, 12c (12.2.1.3.0)

Using Oracle TopLink with the Oracle Database

24.2.1 Using Oracle Platform-Specific APIs) Returning clause Custom expression functions ( REGEXP_LIKE, LOCATE, ATAN2, LOG, CONCAT, SYSDATE (Date

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 Utilities, Release 20c

ADRCI: ADR Command Interpreter

19.9.9 SELECTresults of a query. REGEXP_LIKE Returns rows that match a specified pattern in a specified regular

JDeveloper, 12c (12.2.1.2.0)

Uses of Class oracle.javatools.db.sql.Comparison.Comparator (Oracle Fusion Middleware Java API Reference for Oracle Extension SDK)

Uses of Class oracle.javatools.db.sql.Comparison.Comparatorfragment for regexp_like, which has function format. Comparison ( SQLFragment  left, Comparison.Comparator

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

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

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

PL/SQL Optimization and Tuning

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

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

PL/SQL Optimization and Tuning

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

Database PL/SQL Language Reference, Release 12.2

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

Database PL/SQL Language Reference

PL/SQL Optimization and Tuning

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

Fusion Middleware Solutions Guide for Oracle TopLink, 12c (12.2.1.2.0)

Using Oracle TopLink with the Oracle Database

24.2.1 Using Oracle Platform-Specific APIs) Returning clause Custom expression functions ( REGEXP_LIKE, LOCATE, ATAN2, LOG, CONCAT, SYSDATE (Date


Was this page helpful?