Hi all,
I have a table which needs to be updated.The update condition is the records in the table may or may not change.
eg.
ACC_NO varchar2(20)
NAME varchar2(100)
LAST_AMT number
DEPOSIT_AMT number
the PK is ACC_NO.
The value of LAST_AMT and DEPOSIT_AMT may change, however not all records in the table will have a change of these values.
How can I construct a update statement to ensure that this table is kept up to date.
This table derives the values from another table containing these values.
Please help.
thanks and regards.
I have a table which needs to be updated.The update condition is the records in the table may or may not change.
eg.
ACC_NO varchar2(20)
NAME varchar2(100)
LAST_AMT number
DEPOSIT_AMT number
the PK is ACC_NO.
The value of LAST_AMT and DEPOSIT_AMT may change, however not all records in the table will have a change of these values.
How can I construct a update statement to ensure that this table is kept up to date.
This table derives the values from another table containing these values.
Please help.
thanks and regards.