DBMS Q solve 2010

2010-3.a

select last_name,
TO_CHAR(hire_date, 'ddth "of" month YYYY fmHH:MI:SS AM')
 AS "JOINING DATE"

from employees;


2010-3.B


select emp.last_name,dept.department_name,job.job_title,emp.hire_date

from employees emp,Departments dept, jobs job
where emp.department_id=dept.department_id AND emp.job_id= job.job_id AND (emp.hire_date>='1 jun 1987' AND emp.hire_date<='28 jun 1987');



2010 4.C

insert into jobs values(M_ENGR,'Maintenance Engineer',35000,55000);


2010. 3.c.

select emp.last_name, dept.department_name, job.job_title, emp.hire_date
 from employees emp, departments dept, jobs job
where emp.department_id=dept.department_id
AND emp.job_id=job.job_id
AND dept.department_name= 'IT';