|
Not in my test - I tried to omitt "matched " and it won 't do.
SQL > l
1 MERGE INTO bonuses D
2 USING (SELECT employee_id salary department_id FROM employees
3 WHERE department_id 80) S
4 ON (D.emploWell I 've had my coffee and I still can 't get this to work
SELECT COUNT(*) FROM a
WHERE EXISTS (SELECT * 20
FROM b
WHERE a.unit_id 3D b.unit_id
and a.op_year 3D b.op_yeHi
I am getting the following error while creating the view....
SQL > Create materialized mv_prod
2 refresh fast on commit
3 as select *from products
Create materialized mv_prod
Hi
Thanks a lot for your responses . But somehow people mis understood my
question I was asking about if i "implement co process " to the
following code what to do for error validations . fo |
|
