Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Subtracting from a set of rows/columns

Subtracting from a set of rows/columns

From: Martin T. <bilbothebagginsbab5_at_freenet.de>
Date: 14 Mar 2007 00:03:21 -0700
Message-ID: <1173855801.065464.224050@p15g2000hsd.googlegroups.com>


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

WHERE ORDER_ID = p_new_order_id;
---

Is there a more elegant way to do it?

cheers,
Martin Received on Wed Mar 14 2007 - 02:03:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US