| doubt in Decode [message #89243] |
Wed, 24 December 2003 01:09  |
Ramaprasad
Messages: 7
Registered: December 2003
|
Junior Member |
|
|
Hello oracle experts ,
In the sample table below.,
student marks grade
---------------------
a 75
b 60
c 65
d 45
e 35
I want to have grade as "A" when marks > 70,
"B" when marks between 60 and 74
"C" when marks between 35 and 59
I used Decode function in SQL but it didn't work.
Thanks in advance.
regards,
Ramaprasad
|
|
|
|
| Re: doubt in Decode [message #89245 is a reply to message #89243] |
Thu, 25 December 2003 03:29  |
MKDerb
Messages: 4
Registered: December 2003
|
Junior Member |
|
|
Try to create this function
create or replace function Grades(Degree number) return Varchar
is
v char(1);
begin
if degree >70 then v:='A';
elsif degree between 60 and 70 then v:='B';
elsif degree between 35 and 59 then v:='C';
else v:='F';
end if;
return v;
end;
modify the function as you like
and use it like this statement
select grades(DegreeCol)
from Table;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
