Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Subtracting from a set of rows/columns
Greetings,
The following situation:
TABLE test_counters ...
SORT_NUMBER | TEST_ID | COUNT1 | COUNT2 | COUNT3 | COUNT4 | COUNT5
I need to subtract from all counts of a test_id the values of the
respective count columns for sort_number zero.
(ie: count* = count* - count*_where_sort_number_zero)
I have implemented it now as follows:
---
v_counts test_counter%rowtype;
...
SELECT *
INTO v_counts
FROM test_counters
WHERE SORT_NUMBER=0
and TEST_ID = :p_new_id;
UPDATE MEASURES
SET COUNT1 = COUNT1 - v_counts.count1,
COUNT2 = COUNT2 - v_counts.count2, COUNT3 = COUNT3 - v_counts.count3, COUNT4 = COUNT4 - v_counts.count4, COUNT5 = COUNT5 - v_counts.count5
Is there a more elegant way to do it?
cheers,
Martin
Received on Wed Mar 14 2007 - 02:03:21 CDT