section2 lesson1

1.select last_name,to_char(birthdate,'fxmonth DD,YYYY')
from f_staffs

2.select to_date('January 3,2004','mon dd,RRRR')
from dual

3.select to_date(start_date)as"Promotion on 10th-Feb-2004"
from f_promotional_menus
where code=110

4.select 'Today is the'||' '|| to_char(sysdate,'Ddspth "of" month')||' '||to_char(sysdate,'Year')from dual

5.select id,first_name,last_name,salary,to_char(salary,'$9999.99')
from f_staffs

6.select first_name,last_name,to_number('salary','$9999.99'),to_number('salary','$9999.99')+2000 as "New Salary"
from employees
where last_name='abel'

7.select start_date
from f_promotional_menus
where code=110

8.select to_char(to_date('25-dec-04','Month ddth,YYYY'))from dual
select to_char(to_date('25-dec-04','MONTH ddTH,YYYY'))from dual
select to_char(to_date('25-dec-04','month ddth,YYYY'))from dual

9.select code,to_char(low_range,'$999999.99'),to_char(high_range,'$99999.99')from d_packages

10.select to_date('JUNE 19,2004','fxMONTH DD,RRRR') FROM DUAL