How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
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
7.10 The WHERE Clause → WHERE 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
Using the WHERE Clause → shows: 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
6.3.5 The WHERE Clause → 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 … functions. If you omit the WHERE clause, all rows in the table or view are processed. If you omit the … WHERE clause
Using the WHERE Clause → EXEC 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
Situations Where Hashing Is Useful → cluster key: SELECT... WHERE cluster_key =...; In such cases, the cluster key in the equality
WHERE Clause Usage with LOBs → predicates 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
Where OTT Parameters Can Appear → OTT 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
5.3.7 Using the WHERE Clause → You 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
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
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
INTO Clause WHERE Clause Valid? → Table 9 - 1 shows which uses of host arrays are valid in a SELECT INTO statement: INTO Clause WHERE
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
Where XSU can be Installed → XSU is written in Java, and can live in any tier that supports Java. XSU can be installed on a client system.
8.9 Using the WHERE Clause → EXEC 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
Where Can DBUri Be Used? → : Storing URLs to Related Documents In the case of a travel story Web site where you store travel
Where OTT Parameters Can Appear → Supply 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
Operators Outside the WHERE Clause → Operators 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
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