I have a table as below
create table t_temp_tb(a number,b number);
and data like column a is sequence number and column b contains values for some rows only like below.
Now I would like to update the table as below
ie after selecting from the table
(select a,b from t_temp_tb order by a;)
We do not know how many records exists in the table in advance.
Can you please let me know how can I update?
Because this update needs to be run daily on a table automatically in a job.