King AbdulAziz University



4666594605020Name: Heba A. GogandyID Number: 1334978Date of submission: 3 – NOV – 2015Instructor: Dr.Waqar AhmedName: Heba A. GogandyID Number: 1334978Date of submission: 3 – NOV – 2015Instructor: Dr.Waqar Ahmed-5009491097545Homework Assignment 3 00Homework Assignment 3 Q1:SQL> SELECT RPAD(ENAME,20,' ') || LPAD(JOB,10,' ')FROM EMP;Q2:SQL> SELECT ROUND(MAX(SAL)) MAXIMUM, ROUND(MIN(SAL)), MINIMUM, ROUND(SUM(SAL)) SUM, ROUND(AVG(SAL)) AVERAGEFROM EMP; Q3:SQL> SELECT ROUND((SYSDATE-HIREDATE)/7) WEEKS_WORKEDFROM EMPORDER BY (SYSDATE-HIREDATE)/7;Q4:SQL> SELECT DEPTNO, COUNT(DEPTNO) AS "COUNT(*)"FROM EMPGROUP BY DEPTNOHAVING COUNT(DEPTNO)>4ORDER BY DEPTNO;Q5:SQL> SELECT TO_CHAR(SYSDATE,'DDSPTH,YEAR,YYYY,HH:MI;SS') AS "DATE"FROM DUAL;Q6:SQL> SELECT LPAD((RPAD(ENAME,10,' ')),15,' ') ENAME, TO_CHAR(SAL,'000000000000000') SALFROM EMP; Q7: SQL> SELECT ENAME, CONCAT(SUBSTR(ENAME,1,2),SUBSTR(EMPNO,2,2)) AS "CODE"FROM EMP;Q8:SQL> SELECT ENAME, JOB, DECODE(JOB,'PRESIDENT',(SAL+NVL(COMM,0))*1.2,'SALESMAN',(SAL+NVL(COMM,0))*1.3, SAL+NVL(COMM,0)) AS REVISED_SALARYFROM EMP; Q9:SQL> SELECT ENAME, NVL(TO_CHAR(MGR),'NO MANAGER') AS MANAGER FROM EMP;Q10:SQL> select e.ename, g.grade, e.sal, e.sal+4000 "SALARY_BONUS", d.dname from emp e, salgrade g, dept d where (e.deptno = d.deptno) and (e.sal between g.losal and g.hisal and g.grade =1) and (e.job <> 'SALESMAN')Q11:SQL> Select next_day(sysdate,'FRIDAY')From dual;Q12:SQL> SELECT ADD_MONTHS('31-05-2005',8)FROM DUAL;Q13:SQL> SELECT LAST_DAY(SYSDAY)FROM DUAL;Q14:SELECT SUM (DECODE(JOB,'CLERK',(SAL+(SAL*0.2))/30*5)) "fIVE DAYS SAL", SUM(DECODE(JOB,'MANAGER',(SAL+(SAL*0.25))/30*10)) "TEN DAYS SAL", SUM(DECODE(JOB,'ANALYST',(SAL+(SAL*0.22))/30*7,SAL)) "SEVEN DAYS SAL" FROM EMP;Q15:SQL> SELECT ENAME, SUBSTR(ENAME,2,1) "THE SECOND CHARACTER", SUBSTR(ENAME,4,1) "THE FOURTH CHARATOR"FROM EMP ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download