General discussion

Locked

Update table in Oracle

By dredd ·
hi,
i've an or_trans table wherein i have 3 columns rg_code, colltype, or_amount. my problem is if the value of my rg_code columns equals to 'M1' but his colltype equals to '04' the or_amount will not be save to that record but will go to it's repective record like M1 whos colltype equals to '01'.
how am i going to manipulate these data. i am thinking of dumping the records to a temporary table. but still i've a hardtime putting the right amount to it's place

regards,
danny

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Update table in Oracle

by Stephen Darlington In reply to Update table in Oracle

UPDATE or_trans
SET or_amount = new_value
WHERE rg_code = 'M1'
AND colltype = '04';

Or am I missing something?

Collapse -

Update table in Oracle

by dredd In reply to Update table in Oracle

Poster rated this answer

Collapse -

Update table in Oracle

by dredd In reply to Update table in Oracle

This question was closed by the author

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums