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 UPDATE


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


DML Reference, 10g Release 1 (10.1)

UPDATE

UPDATEThe 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

DML Reference, 10g Release 1 (10.1)

TRIGGER command

UPDATEWhen 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

SQL Reference, 10g Release 1 (10.1)

UPDATE

UPDATEPurpose 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:

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

UPDATE Statement

UPDATE StatementThe 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

DML Reference, 10g Release 1 (10.1)

UPDATE

acquired_objectsacquired 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

SQL Reference, 10g Release 1 (10.1)

UPDATE

Restrictions on the DML_table_expression_clauseUNUSABLE, 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

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

22 Performance Extensions

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

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

11 Object-Relational Datatypes in OCI

Salary Update ExamplesThe 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

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

6 Embedded SQL

6.3.3 The UPDATE StatementUse 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

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

3 Streams Conflict Resolution

Prebuilt Update Conflict HandlersThis 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

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

6 Embedded SQL

6.12 Positioned UpdateUpdate 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

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

A Installing and Configuring Oracle XML DB

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.

Advanced Replication Management API Reference, 10g Release 1 (10.1)

B User-Defined Conflict Resolution Methods

Resolving Update ConflictsFor 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

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

7 Host Tables

7.6.1 Restrictions in UPDATEYou 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:

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

22 Performance Extensions

22.1.3 Standard Update Batching22.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

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

5 Embedded SQL

5.4.8 Positioned UpdateThe 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....

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

11 DBMS_XMLSTORE

Update Processing with DBMS_XMLSTORENow 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

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

17 Result Set Enhancements

17.4.4 Update Conflicts17.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

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

22 Performance Extensions

22.1.2 Oracle Update Batching22.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

Release 1.8, 10g Release 1 (10.1)

Embedded SQL Commands and Directives

UPDATE (Executable Embedded SQL)Purpose To change existing values in a table or in a view's base table.