update a set status=(case when status='YES' then 'NO'
when status='NO' then 'YES'
end)
Showing posts with label oracle 2 values in a column swapping. Show all posts
Showing posts with label oracle 2 values in a column swapping. Show all posts
Saturday, August 18, 2012
Swap YES,NO values in a table column with single update statement.....
update a set status=(case when status='YES' then 'NO'
when status='NO' then 'YES'
end)
Subscribe to:
Posts (Atom)