Submitted Questions

  • Is it possible to update Views? If yes, How, If Not, Why?

    Asish

    • Jan 7th, 2018

    Yes, if the view is derived from one base table. Here you can execute all the DML opperation.

    No, if the view derived from multiple base table.

    Sushil Tembhekar

    • Dec 16th, 2017

    In SQL it is impossible to update the View.
    but, By using "Instead of Trigger" clause in PL/ SQL, it is possible to update the View.