Skip to content
Advertisement

How to insert a Number value which is a difference between field 1 and field 2 of another table in Oracle?

I have a table name ITEM that consist of

And another table name PAYMENT that will require insert.

How do i correctly calculate the differences between PrevValue and CurValue in ITEM and insert them into PAYMENT?

Advertisement

Answer

The query will be, simply INSERT….SELECT:

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement