OraFAQ Forum: SQL & PL/SQL » Decode statement/Case statement

Home » SQL & PL/SQL » SQL & PL/SQL » Decode statement/Case statement

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Decode statement/Case statement [message #22217]

Mon, 30 September 2002 02:41

premila
Messages: 10
Registered: September 2002

Junior Member

How do i use the decode or case statement to clean the data for the following table such that they all show either M or F

Drop table tblEmployees cascade constraints;
create table tblEmployees
(
EmployeeID number(5),
CONSTRAINT pk_employeeid primary key(EmployeeID),
Sex char(6));

sample data
insert into tblEmployees values (1,'M');
insert into tblEmployees values (2,'F');
insert into tblEmployees values (3,'Male');
insert into tblEmployees values (4,'F');
insert into tblEmployees values (5,'Female');
insert into tblEmployees values (6,'M');
insert into tblEmployees values (7,'M');
insert into tblEmployees values (8,'F');
insert into tblEmployees values (9,'F');

Report message to a moderator