Oracle forms updating a view


She has been a non-executive director of Hyperion Solutions since April 14, 2007.

She has been a member of the executive council of Tech Net since March 14, 2013.

Yes, in Oracle, the VIEW continues to exist even after one of the tables (that the Oracle VIEW is based on) is dropped from the database.

However, if you try to query the Oracle VIEW after the table has been dropped, you will receive a message indicating that the Oracle VIEW has errors.

select * from student; ID NAME SCORE ---------- --------------- ---------- 1 Jack 540 2 Rose 3 William 650 4 Caledon 620 5 Fabrizio 600 6 Thomas 7 Ruth 690 11 Brock 705 10 Lizzy 9 Wallace 600 8 Spicer 620 11 rows selected. But it does not work with a merge query (probably because of the update part): “Missing IN or OUT parameter at index:: 1” Would would you advise to retrieve the value of a field (typically an id) of the row that has been inserted or updated?