lesphomework

this is a crazy site for crazy people

Sunday

lesson 4

1.select ROUND(86.678,-2) from dual
2.select upper(title) from where cd_number in (90,91)
3.select last_nameupper(substr(first_name,1,1)) as "User Passwords" from
4.select LOWER(REPLACE('It's a small world', 'It's a small','hello')) from dual
5. select substr('fiddledeedum',10,3)substr('fiddledeedee',1,6) from dual
6. select replace('Mississippi','i','$') from dual
7. select round(5332.342,3) from dual
8. select round(3.14159,-2) from dual
9. select trunc(73.892,-1) from dual
10. select next_day(add_mounths(sysdate, 6),'Firday') from dual
11. select add_months(sysdate,120) as "Future" from dual
12. select add_months('29-FEB-04',48) as "Future" from dual
13. select themes from where themes="%ie%"14. select title, year from where year between 2000 and 2003

0 Comments:

Post a Comment

<< Home