Results for REGEXP_LIKE


41 to 80 of 309 results. Prev  Next
Results per page:  20 |  40  | 60


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

Database Development Guide, Release 18c

Using Regular Expressions in Database Applications

Oracle SQL and POSIX Regular Expression StandardName 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

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

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 Globalization Support Guide, Release 18c

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

Database Utilities, Release 18c

ADRCI: ADR Command Interpreter

19.9.9 SELECTLENGTH MAX MIN NVL REGEXP_LIKE SUBSTR SUM TIMESTAMP_TO_CHAR TOLOWER TOUPPER Parent topic: ADRCI Command Reference

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

SQL Semantics and LOBs

SQL Functions and Operators Supported for Use with LOBsand CLOB s.) Yes Yes Character Functions - Regular Expressions REGEXP_LIKE This function searches a

MySQL, Release 5.5

12.5.2 Regular Expressions

Character Class Name Meaningspecifies how to perform matching. The meaning is as described for REGEXP_LIKE(). Prior to MySQL 8.0.17, the … ) For additional information about how matching occurs, see the description for REGEXP_LIKE(). mysql … specifies how to perform matching. The meaning is as described for REGEXP_LIKE(). Prior to MySQL … #29308212) For

Database PL/SQL Language Reference, Release 12.2

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

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

PL/SQL Static SQL

Fetching Data with Cursor VariablesWHERE REGEXP_LIKE (job_id, ''[ACADFIMKSA]_M[ANGR]'') ORDER BY job_id'; v_employees employees%ROWTYPE … REGEXP_LIKE (job_id, 'S[HT]_CLERK') ORDER BY last_name; LOOP -- Fetches 2 columns into variables FETCH cv

Database PL/SQL Language Reference

PL/SQL Static SQL

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

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

PL/SQL Static SQL

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 12.2

REGEXP_INSTR

REGEXP_INSTRREGEXP_SUBSTR REGEXP_REPLACE and REGEXP_LIKE Condition Appendix C in Oracle Database Globalization

SQL Language Reference, Release 12.2

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 Reference, Release 12.2

REGEXP_SUBSTR

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

Database Development Guide

Using Regular Expressions in Database Applications

Example: Enforcing a Phone Number Format with Regular Expressions; CREATE TABLE contacts ( l_name VARCHAR2(30), p_number VARCHAR2(30) CONSTRAINT c_contacts_pnf CHECK (REGEXP_LIKE (p_number, '^\\(\\d{3}\\) \\d{3}-\\d{4}$')) );

Database PL/SQL Language Reference, Release 12.2

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

MySQL, Release 5.5

12.5.2 Regular Expressions

Regular Expression Syntaxfor REGEXP_LIKE(). For additional information about how matching occurs, see the description for … REGEXP_LIKE(). mysql> SELECT 'Michael!' REGEXP '.*'; +------------------------+ | 'Michael!' REGEXP … that specifies how to perform matching. The meaning is as described for REGEXP_LIKE(). For … additional information about how matching

Database Development Guide, Release 18c

Using Regular Expressions in Database Applications

Table 10-6 Explanation of the Regular Expression ElementsVARCHAR2(30), p_number VARCHAR2(30) CONSTRAINT c_contacts_pnf CHECK (REGEXP_LIKE (p_number, '^\\(\\d

Database Development Guide, 12c Release 1 (12.1)

Using Regular Expressions in Database Applications

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

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





Was this page helpful?

Integrated Cloud Applications & Platform Services