回復： Lab10 hints

軒仔周一 11月 10, 2008 1:42 am

多幾個不同方法,抄起來不會太覺眼 tongue

Hints:
Q1 (不用喇掛...)

Q2 WHERE hiredate BETWEEN add_months(sysdate,-360) and sysdate

Q3 SELECT ename,dname, (months_between(sysdate, hiredate)/12) hiredate FROM emp

Q4 WHERE TO_NUMBER(TO_CHAR(hiredate,'DD'))<16

Q5 SELECT ename,dname FROM emp NATURAL JOIN dept WHERE ename LIKE 'A%'

Q6 (覺得自己有o的取巧所以不post出來了)

ada 周一 11月 10, 2008 1:29 am

kuen 寫到:don't copy all , that is not answer as well

Q1
select ename, sal from emp where sal between 2000 and 3000

Q2
select ename,sal,hiredate, to_char(months_between(sysdate,hiredate)) from emp

Q3
select ename, to_char(months_between(sysdate, hiredate)/12) from emp

Q4
Select ename from emp where to_char(hiredate, 'dd') between 1 and 16

Q5
select ename from emp where ename like 'A%'

Q6
select job, ename, deptno, dname from dept natural join salgrade natural join emp where sal
between losal and hisal and grade = 3

THANKS A LOTS KUEN KUEN,, AS PER YOUR HINTS, FINALLY I COMPLETED LAB 10 LA cheer

kuen 周日 11月 09, 2008 11:59 pm

don't copy all , that is not answer as well

Q1
select ename, sal from emp where sal between 2000 and 3000

Q2
select ename,sal,hiredate, to_char(months_between(sysdate,hiredate)) from emp

Q3
select ename, to_char(months_between(sysdate, hiredate)/12) from emp

Q4
Select ename from emp where to_char(hiredate, 'dd') between 1 and 16

Q5
select ename from emp where ename like 'A%'

Q6
select job, ename, deptno, dname from dept natural join salgrade natural join emp where sal
between losal and hisal and grade = 3