Web Development

General discussion

Gravatar
0 Votes
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.

Thread display: Collapse - | Expand +

All Comments

gravatar
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?

gravatar
Collapse -

Update table in Oracle

by dredd In reply to Update table in Oracle

Poster rated this answer

gravatar
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

Start or search

Related Discussions

Related Forums