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
UPDATE → The UPDATE command moves analytic workspace changes from a temporary area to the database table in … which the workspace is stored. Typically, you use an UPDATE command when you are finished making … changes in a workspace; however, you can also specify UPDATE commands periodically as you go along … . Syntax UPDATE
UPDATE → When the object has been acquired using ACQUIRE in an analytic workspace that is attached in multiwriter mode, specifies that Oracle OLAP executes the specified program immediately after the object is updated. Tip: To specify processing when the entire analytic workspace is updated, create a TRIGGER_AFTER_UPDATE or TRIGGER_BEFORE_UPDATE program. program-name The name of the trigger program. When omitted
UPDATE → Purpose Use the UPDATE statement to change existing values in a table or in the base table of a … Examples Prerequisites For you to update values in a table, the table must be in your own schema or you … must have the UPDATE object privilege on the table. For you to update values in the base table of a … view:
UPDATE Statement → The UPDATE statement changes the values of specified columns in one or more rows in a table or view … . For a full description of the UPDATE statement, see Oracle Database SQL Reference. Syntax … the UPDATE statement in the same order that they appear in the table or view. returning_clause … . Then it runs an UPDATE
acquired_objects → acquired using an ACQUIRE statement. Important: you cannot update an object when it is dimensioned by … an acquired and maintained dimension unless you update that dimension first. workspaces A list of … . Notes Unsaved Changes When you do not use the UPDATE and COMMIT commands, changes made to an analytic … execute a COMMIT statement
Restrictions on the DML_table_expression_clause → UNUSABLE, then the UPDATE statement will fail unless the SKIP_UNUSABLE_INDEXES session parameter has been … you must first initialize it with a value of empty or . You cannot update it with a literal … . Also, if you are updating a LOB value using some method other than a direct UPDATE SQL statement, then … column is part of the
22.1 Update Batching → , by grouping multiple UPDATE, DELETE, or INSERT statements into a single "batch" and having the … update batching and in the Sun Microsystems JDBC 2.0 specification as batch updates. This is especially … variables. Oracle JDBC supports two distinct models for update batching: the standard model, implementing … the Sun Microsystems
Salary Update Examples → The examples in the previous section should give some idea of the flexibility which the Oracle datatypes provide for bind and define operations. The goal of this section is to show how the same operation can be performed in several different ways. The goal is to give you some idea of the variety of ways in which these datatypes can be used in OCI applications. The examples in this section are intended
6.3.3 The UPDATE Statement → Use the UPDATE statement to change the values of specified columns in a table or view. In the … following example, we update the SAL and COMM columns in the EMP table: EXEC SQL UPDATE emp SET sal … values, as the following example shows: EXEC SQL UPDATE emp SET sal = (SELECT AVG(sal)*1.1 FROM emp WHERE … deptno
Prebuilt Update Conflict Handlers → This section describes the types of prebuilt update conflict handlers available to you and how … column lists and resolution columns are used in prebuilt update conflict handlers. A column list is a … list of columns for which the update conflict handler is called when there is an update conflict. The … resolution
6.12 Positioned Update → Update The following skeletal example demonstrates positioned update using the universal ROWID. See also … cur CURSOR FOR SELECT rowid,... FROM my_table FOR UPDATE OF...; EXEC SQL OPEN cur; EXEC SQL FETCH … cur INTO:urowid,...; /* Process data */... EXEC SQL UPDATE my_table SET... WHERE CURRENT OF cur; EXEC SQL CLOSE
Update Configuration, cfg_update() → cfg_update() and cfg_get() If you have a few parameters to update in the configuration file, then you can use … have many parameters to update, then the preceding example may prove too cumbersome. Use instead FTP, HTTP, or Oracle Enterprise Manager.
Resolving Update Conflicts → For update conflicts, a user-defined function should accept the following values for each column in … that you have updated the value of the IN OUT parameter (new) and that you should update the current
7.6.1 Restrictions in UPDATE → You cannot use host tables with the CURRENT OF clause in an UPDATE statement. For an alternative … , see "Mimicking the CURRENT OF Clause". Table 7-2 shows which uses of host tables are valid in an UPDATE statement:
22.1.3 Standard Update Batching → 22.1.3 Stand ard Update Batching Oracle implements the standard update batching model according to … the Sun Microsystems JDBC 2.0 Specification. This model, unlike the Oracle update batching model … .) Notes: Do not mix standard update batching syntax with Oracle update batching syntax in the same
5.4.8 Positioned Update → The following skeletal example demonstrates positioned update using the universal ROWID, which is … . EXEC SQL DECLARE C CURSOR FOR SELECT ROWID,... FROM MYTABLE FOR UPDATE OF... END-EXEC. EXEC SQL … UPDATE MYTABLE SET... WHERE ROWID =:MY-ROWID END-EXEC.... NO-MORE-DATA: EXEC SQL CLOSE C END-EXEC. EXEC SQL FREE:MY-ROWID END-EXEC....
Update Processing with DBMS_XMLSTORE → Now that you know how to insert values into the table from XML documents, let us see how to update … only certain values. If you get an XML document to update the salary of an employee and also the … department that she works in: 7369 1800 30 2290 2000 31-DEC-1992 you can call the update … processing to update
17.4.4 Update Conflicts → 17.4.4 Update Co nflicts It is important to be aware of the following facts regarding updatable … . The drivers do not check for conflicts with a result set DELETE or UPDATE operation. A conflict will … occur if you try to perform a DELETE or UPDATE operation on a row updated by another committed … long as the ROWID is still valid
22.1.2 Oracle Update Batching → 22.1.2 Oracle Update Bat ching The Oracle update batching feature associates a batch value (limit … ) with each prepared statement object. With Oracle update batching, instead of the JDBC driver … by choosing to manually execute the pending batch. Notes: Do not mix standard update batching syntax … with Oracle