Results for REGEXP_LIKE


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


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] nested_table Null conditions expr IS [ NOT ] NULL REGEXP_LIKE condition REGEXP_LIKE(source_char, pattern

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





Was this page helpful?

Integrated Cloud Applications & Platform Services