case when condition then value
     when condition then value
     when condition then value
     else vale
end as name

 create table RB_TEST( A NUMBER);

INSERT INTO RB_TEST(A)VALUES(1);
INSERT INTO RB_TEST(A)VALUES(2);
INSERT INTO RB_TEST(A)VALUES(3);
COMMIT;


SELECT A ,  CASE WHEN A = 1 THEN 'ONE'
                 WHEN A = 2 THEN 'TWO'
                 WHEN A = 3 THEN 'THREE'
            END IN_WRODS
FROM RB_TEST


         A IN_WR
---------- -----
         1 ONE
         2 TWO
         3 THREE

case
when [No_of_files] Between 1 And 10 And [Timedur] Between 1 And 30)
     ( ([No_of_files] Between 11And 3 And [Timedur] Between 1 And 60) then
 'Yes'
else 
'No'
end