1)
select e.ename ,min(d.sal)
from emp e , emp d 
where d.mgr=e.empno(+)
and d.mgr is not null
group by e.ename
having min(d.sal)>1000
/
2)
select e.ename as manager,d.hiredate as emphiredate,d.ename employee
,e.hiredate as managerhiredate
from emp e , emp d 
where d.mgr=e.empno(+)
and d.hiredate<e.hiredate
/
3)
variable deis varchar2(10);
accept deis prompt 'enter emp'
select e.ename ,e.deptno,d.ename
from emp e , emp d
where d.deptno=e.deptno
and e.ename=:deis;
/
4)
select ename ,sal
from emp
where sal>(select max(sal) from emp
where job='CLERK')
/
5)
variable deis1 number;
accept deis1 prompt 'Enter the employeno';

declare
deis1 emp.empno%type;
begin
 if (select sal from emp where empno =:deis1 ) < 1000 then
  update table emp set comm = sal * 1.1;
 end if
  if (select sal from emp where empno =:deis1 ) < 1500 then
  update table emp set comm = sal * 1.15;
 end if
 if (select sal from emp where empno =:deis1 ) > 2000 then
  update table emp set comm = sal * 1.2;
 end if
 if (select sal from emp where empno =:deis1 ) is null then
  update table emp set comm = 0;
 end if
end;
/
6)
Create or replace package my_package is 
procudure print_it(deis in varchar2)
return number is
don number;
procudure print_it(deis in date)
return varchar2 is
end;
/
Create or replace package body my_package is 
procudure print_it(deis in varchar2)
return number is
don number;
begin
		don:=deis format 999,999.00;
end
procudure print_it(deis in date)
return varchar2 is
don varchar2;
		don:=deis format FmMonthd/dd/yyyy;
end
end;
/