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 LIKE


1 to 20 of 1634 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


SQL Reference, 10g Release 1 (10.1)

LIKE

LIKEThe LIKE conditions specify a test involving pattern matching. Whereas the equality operator … (=) exactly matches one character value to another, the LIKE conditions match a portion of one character … value to another by searching the first value for the pattern specified by the second. LIKE … escape character, then you can use

JDBC Developer's Guide and Reference, 10g Release 1 (10.1)

25 Reference Information

25.3.4 LIKE Escape CharactersThe characters " % " and " _ " have special meaning in SQL LIKE clauses (you use " % " to match … LIKE '&_%' {ESCAPE '&'}"); // Iterate through the result and print the employee numbers while … = stmt.executeQuery("SELECT empno FROM emp WHERE ename LIKE '\\_%' {escape '\\'}");

Globalization Support Guide, 10g Release 1 (10.1)

9 SQL and PL/SQL Programming in a Global Environment

LIKE Conditions for Different Length SemanticsThe LIKE conditions specify a test that uses pattern-matching. The equality operator (=) exactly … matches one character value to another, but the LIKE conditions match a portion of one character value … to another by searching the first value for the pattern specified by the second. LIKE calculates

Database, 10g Release 1 (10.1)

Authentication, Authorization, and Access Control

How can I change what the password box looks like?authentication scheme. There is no way to change what this login box looks like if you are using basic authentication.

Error Messages, 10g Release 1 (10.1)

16 ORA-29250 to ORA-32775

ORA-32627: illegal pattern in MODEL FOR LIKE loopstatement and rewrite if necessary. ORA-32627: illegal pattern in MODEL FOR LIKE loop

Error Messages, 10g Release 1 (10.1)

33 RMAN-00550 to RMAN-20506

RMAN-06143: LIKE may only be specified with COPYthe DEVICE TYPE option and re-run the command. RMAN-06143: LIKE may only be specified with COPY

Error Messages, 10g Release 1 (10.1)

4 ORA-01500 to ORA-02098

ORA-01560: LIKE pattern contains partial or illegal characterORA-01560: LIKE pattern contains partial or illegal character

Error Messages, 10g Release 1 (10.1)

33 RMAN-00550 to RMAN-20506

RMAN-06141: cannot specify ARCHIVELOG LIKE option with RESTOREcommand. RMAN-06141: cannot specify ARCHIVELOG LIKE option with RESTORE

Error Messages, 10g Release 1 (10.1)

14 ORA-19400 to ORA-24276

ORA-23407: object name string must be shaped like "schema"."object" or "object"with ALTER ANY MATERIALIZED VIEW privileges. ORA-23407: object name string must be shaped like "schema"."object" or "object"

Error Messages, 10g Release 1 (10.1)

33 RMAN-00550 to RMAN-20506

RMAN-06409: LIKE clause in LIST BACKUP OF ARCHIVELOG is not supportedRMAN-06409: LIKE clause in LIST BACKUP OF ARCHIVELOG is not supported

Error Messages, 10g Release 1 (10.1)

16 ORA-29250 to ORA-32775

ORA-32640: FOR LIKE loops are not allowed for multi-byte character typesstatement and rewrite if necessary. ORA-32640: FOR LIKE loops are not allowed for multi-byte character types

Performance Tuning Guide, 10g Release 1 (10.1)

17 Optimizer Hints

The FULL hint explicitly chooses a full table scan for the specified table. full_hint::= Text description…CLUSTER The CLUSTER hint explicitly chooses a cluster scan to access the specified table. It applies only to clustered objects. cluster_hint::= Text description of the illustration cluster_hint.gif For a description of the queryblock syntax, see "Specifying a Query Block in a Hint". For a description of the tablespec syntax, see "Specifying Global Table Hints". HASH

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-01470: The escape character in the like-predicate must be a literal or a variable of type CHARlike-predicate must be a literal or a variable of type CHAR

Error Messages, 10g Release 1 (10.1)

18 ORA-33000 to ORA-37134

ORA-33052: XSAGDNGL25 AGGMAP workspace object is a dimensioned AGGMAP; it can only be used to aggregate…workspace object is a dimensioned AGGMAP; it can only be used to aggregate like-dimensioned variables.

Error Messages, 10g Release 1 (10.1)

36 PLS-00049 to PLS-01913

PLS-01468: The first argument of the like-predicate must be a column of type character stringthe like-predicate must be a column of type character string

Packages and Types Reference, 10g Release 1 (10.1)

169 ANYDATASET TYPE

ExceptionsDBMS_TYPES.invalid_parameters: dtype is invalid (not fully constructed, and like errors.)

2 Day DBA, 10g Release 1 (10.1)

7 Administering Users and Security

Using a Shortcut to Create UsersCreate Like. Click Go. The Create User General page appears for a new user with the same attributes

2 Day DBA, 10g Release 1 (10.1)

3 Getting Started with Oracle Enterprise Manager

SQL Statements and Other Management Tools: SQL*Plus and i SQL*Plusoperations on the database like startup and shutdown, object creation, and schema management. The … underlying operations are performed using Structured Query Language (SQL) statements. SQL is an English-like

2 Day DBA, 10g Release 1 (10.1)

Send Us Your Comments

Send Us Your Commentsfeatures did you like most about this manual? If you find any errors or have any other suggestions … , Mailstop 4op11 Redwood Shores, CA 94065 USA If you would like a reply, please give your name, address

Programmer's Guide, 10g Release 1 (10.1)

Bind, Define, and Describe Functions

mode IN The valid modes for this parameter are: OCI_DEFAULT - This is default mode. OCI_BIND_SOFT -…When mode is set to OCI_DATA_AT_EXEC, do not provide values for valuep, indp, alenp, and rcodep in the main call. Pass zeroes for indp and alenp. Provide the values through the callback function registered using OCIBindDynamic(). When the allocated buffers are not required any more, they should be freed by the client.