Updating views in oracle

Rated 3.97/5 based on 989 customer reviews

That signals to Oracle that your View is meant for querying only.

SQL SET SERVEROUTPUT ON BEGIN UPDATE employees SET salary = 10000 WHERE employee_id = 9999; IF SQL%ROWCOUNT = 0 THEN -- Manually raise the NO_DATA_FOUND exception.

Once committed, the only way you can revert a change is to issue a new DML statement to alter the data.

Several statements can be grouped together to form a single transaction.

Data Definition Language (DDL) commands perform an implicit commit, which also confirms all outstanding DML changes in the current session.

If you decide you don't want to keep some uncommitted changes, you can throw them away using using the It's possible to update the base table associated with a view.

Leave a Reply