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. Thanks, Hi egavaldo, MERGE doesn’t support the RETURNING clause and going by this Ask Tom thread, the feature isn’t likely to be available anytime soon.
The purpose of the WITH CHECK OPTION is to ensure that all UPDATE and INSERTs satisfy the condition(s) in the view definition.
If they do not satisfy the condition(s), the UPDATE or INSERT returns an error.
To refer to the remote database in a subquery, append the database link name to the table names in the FROM clause of the subquery.
An example of this is shown in the following listing: NOTE If you do not append the database link name to the table names in the FROM clause of UPDATE subqueries, tables in the local database will be used.
A view is nothing more than a SQL statement that is stored in the database with an associated name.
A view is actually a composition of a table in the form of a predefined SQL query.This is true even if the table being updated is in a remote database.In this example, the remote BOOKSHELF table is updated based on the RATING value on the remote BOOKSHELF table.Let’s say this is how STUDENT_N looks before it is merged with STUDENT: merge into student a 2 using 3 (select id, name, score 4 from student_n) b 5 on (= b.id) 6 when matched then 7 update set = 8 , a.score = b.score 9 when not matched then 10 insert (a.id, a.name, a.score) 11 values (b.id, b.name, b.score); 5 rows merged.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?To create a view, a user must have the appropriate system privilege according to the specific implementation.