Updating a view in plsql


24-Jan-2020 15:19

Once we open a cursor having a FOR UPDATE clause, all the rows returned by the SELECT statement are locked for our changes until a commit or a rollback is placed to release the lock.

After a TCL operation is performed, the cursor pointer gets reset and the cursor will be no longer accessible, thus results in an error when fetched further as shown below.

In the below example, the cursor CUR is associated with a SELECT statement having the tables EMPLOYEES and joined in its FROM clause. EMPLOYEE_ID clause in the below snippet locks up only rows of the EMPLOYEES table, thus making the DEPARTMENTS table available for modification to the other session users. For this, the cursor CUR is associated with a SELECT statement joining the EMPLOYEES and the DEPARTMENTS tables with a FOR UPDATE OF clause on the employee ID.

When we try to update the salary column of the EMPLOYEES table using the WHERE CURRENT OF clause, the block fails with an ORA-01410: invalid ROWID error as there is no way to specify the This scenario can be manhandled by fetching the rowid of the intended table in the cursor associated SELECT statement and using it in the WHERE clause of the DELETE or the UPDATE statement instead of the WHERE CURRENT OF clause as shown in the below listing. For complete notes on programming in PL/SQL, we recommend the book Advanced PL/SQL: The Definitive Reference by Boobal Ganesan.

Hence updating a view also results in update of main table.

In this table when data inserted, profit calculated with a stored procedure.

You can find the original table definitions in the "$ORACLE_HOME/rdbms/admin/utlsampl.sql" script.

All Data Manipulation Language (DML) changes are done as part of a transaction.

Hello, so far in my OAF programming, I have always selected one particular row from a table and saved from it.

updating a view in plsql-16

1840 1929 dating old photograph

Now I have a requirement where in my table, fields from more than one row shall have to be updated.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.



The city's economy was substantially based on manufacturing, ushering in an era of innovation with several notable inventions and developments coming out of the city over the years, such as gasoline pumps (1885), the refrigerator (1913), and in 1972, the first home video game console.… continue reading »


Read more

That’s because there’s no middle-man or person in between you and the buyer that’s taking a ‘cut’ from the money earned.… continue reading »


Read more

Site is hosted in Russian Federation and links to network IP address 185.134.204.6. None of the above-the-fold content on your page could be rendered without waiting for the following resources to load.… continue reading »


Read more

You can see the model of your motherboard by using any hardware information tool such as Speccy or CPU-Z.… continue reading »


Read more

Azteca's Bar & Grill in Houston | Azteca's Bar & Grill (713) 526 ... Categories: Restaurants, Pizza, All Bars, Pubs, & Clubs, Bars & Pubs ...… continue reading »


Read more

Modern day life is hectic, and singles everywhere are finding it increasingly difficult to find a partner to date. Iam tired of being single so Iam seeking a serious relationship that would lead to a serious marriage with kids. … continue reading »


Read more

Then visitors may choose from categories like teens (18 ), blondes or redheads!… continue reading »


Read more