Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Ask Question. Asked 2 years, 9 months ago. Active 2 years, 9 months ago. Viewed 10k times. Marmite Bomber Add a comment. Active Oldest Votes. You could also use a merge instead of an update, e. Alex Poole Alex Poole k 9 9 gold badges silver badges bronze badges. Thank you! If the client does not specify this header in the request the server will pick a default version for the API.
Allowed Values: [ "1", "2", "3", "4", "5", "6" ]. Root Schema : valueSets-values-item. Maximum Length: Read Only: true. Title: Description. Title: Enabled. Title: End Date. Title: Independent Value. Title: Sort Order. Title: Start Date. If table or the base table of view contains one or more domain index columns, then this statement executes the appropriate indextype update routine. You cannot update rows in a read-only materialized view. If you update rows in a writable materialized view, then the database updates the rows from the underlying container table.
However, the updates are overwritten at the next refresh operation. If you update rows in an updatable materialized view that is part of a materialized view group, then the database also updates the corresponding rows in the master table.
Oracle Data Cartridge Developer's Guide for more information on the indextype update routines. Specify the name of the partition or subpartition within table targeted for updates.
You need not specify the partition name when updating values in a partitioned table. Specify a complete or partial name of a database link to a remote database where the object is located.
You can use a database link to update a remote object only if you are using Oracle Database distributed functionality. If you omit dblink, then the database assumes the object is on the local database. Regardless of its form, it must return a collection value—that is, a value whose type is nested table or varray.
This process of extracting the elements of a collection is called collection unnesting.
0コメント