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 2697 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Reference, 9i Release 2 (9.2.0.2)

Executables

-updateby -pk. When you use -update, you must specify a primary key with -pk.

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: SAVEPOINT to UPDATE, 8 of 8

UPDATEPurpose Use the UPDATE statement to change existing values in a table or in a view's base table.

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: ALTER CLUSTER to ALTER SEQUENCE, 2 of 21

UPDATEThe CALL and EXPLAIN PLAN statements are supported in PL/SQL only when executed dynamically. All other DML statements are fully supported in PL/SQL.

Objects for OLE, 9i Release 2 (9.2.0.2)

Update Method

Update MethodMaster Index Feedback Update Method Applies To ODynaset OBinder Description This method saves … dynaset changes to the Oracle database. Usage oresult Update (void) Remarks For ODynaset, Update is the … SetFieldValue or SetValue. Call Update. Calling Update saves to the Oracle database the changes that

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Embedded SQL

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

Objects for OLE, 9i Release 2 (9.2.0.2)

Update Method

Update MethodFeedback Update Method See Also Example Applies To OraDynaset Description Saves the copy buffer to the … specified dynaset. Usage oradynaset.Update oradynaset.DbUpdate Remarks Update completes an AddNew or … session. Note that once you call Update on a given row in a dynaset in a global transaction (i.e … optionally

JDBC Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Result Set Enhancements

Update Conflictsfor 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 transaction. The Oracle JDBC … valid when a driver tries to send an UPDATE or DELETE operation to the database, the operation will … conflicts, use the Oracle

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 52 of 52

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 Oracle9i SQL Reference.

JDBC Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Performance Extensions

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. With Oracle8 i release 8.1.6 and higher, Oracle JDBC supports two distinct models for update … Microsystems JDBC

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Objects

OBJECT UPDATEEXEC SQL [AT [:]database] [FOR [:]count] OBJECT UPDATE:obj. For persistent objects, this statement

SQLJ Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Performance and Debugging

Update BatchingUpdate batching (referred to as batch updates in the Sun Microsystems JDBC 2.0 specification … ) allows UPDATE, DELETE, and INSERT statements that are batchable and compatible (as discussed below) to be … by both Oracle9 i JDBC and Oracle9 i SQLJ. Update batching is typically used for an operation that … is executed repeatedly

Reference Guide for Microsoft SQL Server and Sybase Adaptive Server Migrations, 9i Release 2 (9.2.0.2)

Microsoft SQL Server, Sybase Adaptive Server, and Oracle Compared

UPDATE Statementreferenced by a view. Table 2-9 UPDATE Statement in Oracle and Microsoft SQL Server and Sybase … Adaptive Server   Microsoft SQL Server Oracle Syntax: UPDATE [[database.]owner.] {table | view} SET … .]table | view]... [WHERE condition] Syntax: UPDATE [user.]{table | view} [@dblink] SET [[ user.] {table … to update

Objects for OLE, 9i Release 2 (9.2.0.2)

Update Method

Update MethodMaster Index Feedback Update Method Applies To ORef Description Flushes the modified referenceable … object to the server. Usage void Update (void) const throw( OException ) Arguments none Remarks … Update completes the Edit operation and commits the changes to the database unless BeginTrans is pending

Developer's Guide to the OLAP DML, 9i Release 2 (9.2.0.2)

Defining and Working with Analytic Workspaces, 5 of 9

UPDATE CommandThe UPDATE command moves analytic workspace changes from a temporary area to the database table in … committed when you execute a COMMIT command, then you must first update the workspace using the UPDATEUPDATE command is show below. UPDATE [awname1 [awname2...]] An awname argument specifies the name

Pro*COBOL® Programmer's Guide, 9i Release 2 (9.2.0.2)

Embedded SQL

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....

OLAP User's Guide, 9i Release 2 (9.2.0.2)

Upgrading From Express Server, 6 of 7

UPDATE and COMMITThe UPDATE command moves analytic workspace changes from a temporary area to the database table in … be committed when you execute the COMMIT command, then you must first update the workspace using … the UPDATE command. Changes that have not been moved to the table are not committed. The COMMIT

Objects for OLE, 9i Release 2 (9.2.0.2)

Update Method Example

Update Method ExampleFeedback Update Method Example This example demonstrates the use of AddNew and Update to add a new record … = 500 OraDynaset.Fields("DEPTNO").Value = 30 'End the AddNew and Update the dynaset

Objects for OLE, 9i Release 2 (9.2.0.2)

Select for Update

Select for UpdateMaster Index Feedback Select for Update Normally, when a dynaset is created, rows are not locked in … include the FOR UPDATE construct. Unfortunately, the FOR UPDATE construct undermines the normal … dynaset operations. You may use FOR UPDATE, but it is not recommended. Dynasets created with FOR UPDATE

Pro*COBOL® Programmer's Guide, 9i Release 2 (9.2.0.2)

Embedded SQL Statements and Precompiler Directives

UPDATE (Executable Embedded SQL)update values in a table or snapshot, the table must be in your own schema or you must have UPDATE … privilege on the table. For you to update values in the base table of a view, the owner of the schema … containing the view must have UPDATE privilege on the base table. Also, if the view is in a schema … other

Objects for OLE, 9i Release 2 (9.2.0.2)

SELECT ... FOR UPDATE Example

''SELECT ... FOR UPDATE'' ExampleFeedback ''SELECT... FOR UPDATE'' Example This example demonstrates the use of SELECT... FOR UPDATE to … UPDATE, or an error will occur. OraSession.BeginTrans 'Create the OraDynaset Object Set OraDynaset … = OraDatabase.CreateDynaset("select * from emp FOR UPDATE", 0&) ' Create a field object for faster access