Hi I have two materialised view table. The example for both the table is as below: 1.input_signal_quality 2.connection_collect_arrays
I want to replace the null value in 1st table in column: quality_type_number to 127. and then match the updated view with the last table to see untill all the value is changed. But I do not know how to do interation and loop in sql. I tried to change column values with Update statement, which is below:
UPDATE input_signal_quality_with_all_records
SET quality_type_number = 127
WHERE input_signal = 'null'
But its throwing an error: cannot change materialized view "input_signal_quality_with_all_records.
I am very new to sql so I do not know how to proceed. Please kindly guide me.
