Update statement in oracle function

R Programming. React Native. Python Design Patterns. Python Pillow. Python Turtle. Verbal Ability. Interview Questions. Company Questions. Artificial Intelligence.

Cloud Computing. Data Science. Angular 7. Find centralized, trusted content and collaborate around the technologies you use most. Connect and share knowledge within a single location that is structured and easy to search. If they do, I need to replace it with just a space character. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 9 years, 4 months ago. Active 4 years ago. Viewed 72k times. Specify the schema containing the object to be updated. If you omit schema , then the database assumes the object is in your own schema. Specify the name of the table, view, materialized view, or the columns returned by a subquery to be updated. If you specify view , then the database updates the base table of the view.

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.