Results for REGEXP_LIKE


1 to 60 of 302 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 C 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

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

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

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

SQL-Based Property Graph Query and Analytics

4.1 Simple Property Graph Queriesregexp_like(v, '([aeiou])\\1', 'i'); 6 1 name Jordan Peele 6 1 show Key and Peele 54 1 name John … - filter(INTERNAL_FUNCTION(\"V\") AND REGEXP_LIKE (\"V\",U'([aeiou])\\005C1','i') AND \"T\"=1 AND … ): --------------------------------------------------- 4 - filter(INTERNAL_FUNCTION(\"V\") AND REGEXP_LIKE (\"V\",U'([aeiou])\\005C1','i')

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

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

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

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

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

SQL Language Quick Reference, Release 18c

SQL Conditions

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

JDeveloper, 12c (12.2.1.3.0)

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

Class Comparison, SQLFragment [] argsL) Constructs a new comparison fragment for regexp_like, which has function format … , SQLFragment[] argsL) Constructs a new comparison fragment for regexp_like, which has function format

JDeveloper, 12c (12.2.1.3.0)

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

Class Comparison, SQLFragment [] argsL) Constructs a new comparison fragment for regexp_like, which has function format … , SQLFragment[] argsL) Constructs a new comparison fragment for regexp_like, which has function format

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





Was this page helpful?

Integrated Cloud Applications & Platform Services