Updating a view in plsql registration dating site from greece
Can anyone please let me know how to accomplish this.
RAISE NO_DATA_FOUND; END IF; DBMS_OUTPUT.put_line('NO_DATA_FOUND Not Raised'); EXCEPTION WHEN NO_DATA_FOUND THEN DBMS_OUTPUT.put_line('NO_DATA_FOUND Raised'); END; / NO_DATA_FOUND Raised PL/SQL procedure successfully completed.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. In this scenario, the cursor result set can be limited using the traditional When we associate a SELECT statement with more than one table joined together to a cursor with a FOR UPDATE clause, we end up locking all the tables in the FROM clause of the SELECT statement, where we just need to lock a single table for our purpose.The FOR UPDATE OF clause helps us in locking up the intended table rather all available tables.
Search for updating a view in plsql:
This is a complete book on PL/SQL with everything you need to know to write efficient and complex PL/SQL code.