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 WHERE


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


DML Reference, 10g Release 1 (10.1)

FORECAST

where:argument is one or more of the following:      ALPHA  n      BETA  n      GAMMA  n      STSMOOTHED  n  STSEASONAL  n-series  STTREND  n      FCSMOOTHED  name      FCSEASONAL  name      FCTREND  name Arguments

Pro*COBOL® Programmer's Guide, 10g Release 1 (10.1)

7 Host Tables

7.10 The WHERE ClauseWHERE JOB =:JOB-TITLE END-EXEC. were treated like the following statement PERFORM VARYING I FROM 1 BY … 1 UNTIL I = 50 SELECT MGR INTO:MGR-NUMBER(I) FROM EMP WHERE JOB =:JOB_TITLE(I) END-EXEC END … -PERFORM. because multiple rows might meet the WHERE-clause search condition, but only one output variable … be ambiguous if the statement

Release 1.8, 10g Release 1 (10.1)

Using Host Arrays

Using the WHERE Clauseshows: EXEC SQL DECLARE emp_cursor CURSOR FOR SELECT ENAME, SAL FROM EMP WHERE EMPNO =:emp_number … UPDATE EMP SET SAL =:new_salary WHERE CURRENT OF emp_cursor; However, you cannot use the FOR clause with … =:new_salary WHERE CURRENT OF emp_cursor;... EXEC SQL FOR:limit DELETE FROM EMP WHERE CURRENT OF emp_cursor; Using

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

6 Embedded SQL

6.3.5 The WHERE ClauseUse the WHERE clause to SELECT, UPDATE, or DELETE only those rows in a table or view that meet your … search condition. The WHERE-clause search condition is a Boolean expression, which can include … functions. If you omit the WHERE clause, all rows in the table or view are processed. If you omit the … WHERE clause

Release 1.8, 10g Release 1 (10.1)

Using Embedded SQL

Using the WHERE ClauseEXEC SQL DELETE FROM EMP WHERE DEPTNO =:dept_number; You can use the optional WHERE clause to … specify the condition under which rows are deleted. Using the WHERE Clause

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

18 Managing Hash Clusters

Situations Where Hashing Is Usefulcluster key: SELECT... WHERE cluster_key =...; In such cases, the cluster key in the equality

Application Developer's Guide - Large Objects, 10g Release 1 (10.1)

9 SQL Semantics and LOBs

WHERE Clause Usage with LOBspredicates of the WHERE clause. For example, the LENGTH function can be included in the predicate of the … WHERE clause: create table t (n number, c clob); insert into t values (1, 'abc'); select * from t … where c is not ; select * from t where length(c) > 0; select * from t where c like '%a%'; select

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

14 Using the Object Type Translator with OCI

Where OTT Parameters Can AppearOTT parameters can appear on the command line, in a CONFIG file named on the command line, or both. Some parameters are also allowed in the intype file. OTT is invoked as follows: OTT username/password parameters If one of the parameters on the command line is config=filename additional parameters are read from the configuration file filename. In addition, parameters are also read from a default configuration

Pro*COBOL® Programmer's Guide, 10g Release 1 (10.1)

5 Embedded SQL

5.3.7 Using the WHERE ClauseYou use the WHERE clause to select, update, or delete only those rows in a table or view that meet … your search condition. The WHERE-clause search condition is a Boolean expression, which can include … scalar host variables, host arrays (not in SELECT statements), and subqueries. If you omit the WHERE … clause, all rows in the

Release 1.8, 10g Release 1 (10.1)

Using Host Arrays

SET Clause WHERE Clause Valid?statement: SET Clause WHERE Clause Valid? array array yes scalar scalar yes array scalar no scalar array no Table 9 - 2. Host Arrays Valid in UPDATE

Pro*FORTRAN® Supplement to the Oracle Precompilers Guide, 10g Release 1 (10.1)

Implementing Dynamic SQL Method 4

Where Is the Information Stored?statement falls into this category: * Dynamic SQL statement STMT = 'DELETE FROM EMP WHERE DEPTNO = 30 … SET COMM =:C WHERE EMPNO =:E' rrTo execute a dynamic SQL statement that contains select-list items … variable. Where Is the Information Stored? All the information Oracle needs about select-list items

Release 1.8, 10g Release 1 (10.1)

Using Host Arrays

INTO Clause WHERE Clause Valid?Table 9 - 1 shows which uses of host arrays are valid in a SELECT INTO statement: INTO Clause WHERE

Pro*COBOL® Programmer's Guide, 10g Release 1 (10.1)

7 Host Tables

SET Clause WHERE Clause Valid?Table 7-2 Host Tables Valid in UPDATE SET Clause WHERE Clause Valid? table table yes scalar scalar yes table scalar no scalar table no

Oracle® XML Developer's Kit Programmer's Guide, 10g Release 1 (10.1)

7 XML SQL Utility (XSU)

Where XSU can be InstalledXSU is written in Java, and can live in any tier that supports Java. XSU can be installed on a client system.

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

8 Host Arrays

8.9 Using the WHERE ClauseEXEC SQL SELECT mgr INTO:mgr_number FROM emp WHERE job =:job_title; were treated like the imaginary … statement for (i = 0; i because multiple rows might meet the WHERE-clause search condition, but only … other hand, it would not be ambiguous if the statement EXEC SQL UPDATE emp SET mgr =:mgr_number WHERE … empno IN (SELECT empno

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

17 Creating and Accessing Data Through URLs

Where Can DBUri Be Used?: Storing URLs to Related Documents In the case of a travel story Web site where you store travel

Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

6 Object Type Translator Utility

Where OTT Parameters Can AppearSupply OTT parameters on the command line, in a CONFIG file named on the command line, or both. Some parameters are also allowed in the INTYPE file. The OTT utility is invoked as follows: OTT parameters You can name a configuration file on the command line with the CONFIG parameter as follows: CONFIG=filename If you name this parameter on the command line, then additional parameters are read from

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

9 Defining Operators

Operators Outside the WHERE ClauseOperators occurring outside the WHERE clause are evaluated using the functional implementation. For … the functional implementation for the operator if the operator appears outside the WHERE clause. If

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

8 Host Arrays

SET Clause WHERE Clause Valid?Table 8-2 Host Arrays Valid in an UPDATE SET Clause WHERE Clause Valid? array array yes scalar scalar yes array scalar no scalar array no

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

8 Host Arrays

INTO Clause WHERE Clause Valid?Table 8-1 Valid Host Arrays for SELECT INTO INTO Clause WHERE Clause Valid? array array no scalar scalar yes array scalar yes scalar array no