FilesExpand file tree

master

/

_627.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

11 lines (9 loc) · 175 Bytes

master

/

_627.sql

Copy path

Top

File metadata and controls

• Code
• Blame

11 lines (9 loc) · 175 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

--solution 1:

update salary

set sex = CHAR(ASCII('f') ^ ASCII('m') ^ ASCII(sex));

--solution 2:

update salary

set sex = case sex

when 'm' then 'f'

else 'm'

end;