Update Oracle statement

Question

I have 2 fields code and house

code                                house 

01-001-0001-0001-0001                 6
01-001-0001-0001-0002                 6 
01-001-0001-0001-0003                 6
01-001-0001-0001-0004                 6
01-001-0001-0001-****                 6

01-001-0001-0002-0001                 8
01-001-0001-0002-0002                 8
01-001-0001-0002-0003                 8
01-001-0001-0002-****                 8

How can I update house = null to obtain

code                                house 

01-001-0001-0001-0001                 6
01-001-0001-0001-0002                  
01-001-0001-0001-0003                 
01-001-0001-0001-0004                 
01-001-0001-0001-****

01-001-0001-0002-0001                 8
01-001-0001-0002-0002                 
01-001-0001-0002-0003
01-001-0001-0002-****

Gordon Linoff · Accepted Answer · 2017-04-10 13:46:46Z

4

How about this:

update t
    set house = NULL
    where code not like '%-0001';

If you just want this as the result of a select query:

select code,
       (case when code like '%-0001' then house end) as house
from t;

answered Apr 10, 2017 at 13:46

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Update Oracle statement

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related