Updating a view in plsql Naked women in dating sites
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.
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.