Updating a view in plsql Naked women in dating sites

Posted by / 19-Jul-2020 11:51

This is a complete book on PL/SQL with everything you need to know to write efficient and complex PL/SQL code.

The row limiting clause introduced in the Oracle version 12c, Fetch First ..

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

Now I have a requirement where in my table, fields from more than one row shall have to be updated.

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

This was about updating a view but one quick note I would like to append: When you insert any record in a VIEW it’ll get inserted in your main table too and if you delete that record from VIEW the same record would be delete from table too.

updating a view in plsql-4updating a view in plsql-81updating a view in plsql-5

SALES is mutating, trigger/function may not see it ORA-06512: at "SALES. UPDATE_PROFIT_TRIGGER", line 6 ORA-04088: error during execution of trigger 'SALES.

One thought on “updating a view in plsql”