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


21 to 40 of 299 results. previous page Prev  Next next page
Results per page:   20  | 40 | 60


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