مبتدا

السلام عليكــم ورحمـة الله وبركاتــه

اريد طريقة تسمية الحقل بطريقة متناسقة انا كتبت الكود هذا

select

empno no ,

ename name ,

job ,

mgr manager ,

hiredate ,

sal salary ,

comm ,

sal + nvl(comm,0) total ,

deptno "number of job"

from emp

order by ename

/

الناتج طلع

NO NAME JOB MANAGER HIREDATE SALARY COMM TOTAL number of job

--------- ---------- --------- ---------- -------- ---------- ---------- ---------- -------------

7876 ADAMS CLERK 7788 23/05/87 1100 1100 20

7499 ALLEN SALESMAN 7698 20/02/81 1600 300 1900 30

7698 BLAKE MANAGER 7839 01/05/81 2850 2850 30

7782 CLARK MANAGER 7839 09/06/81 2450 2450 10

7902 FORD ANALYST 7566 03/12/81 3000 3000 20

7900 JAMES CLERK 7698 03/12/81 950 950 30

7566 JONES MANAGER 7839 02/04/81 2975 2975 20

7839 KING PRESIDENT 17/11/81 5000 5000 10

7654 MARTIN SALESMAN 7698 28/09/81 1250 1400 2650 30

7934 MILLER CLERK 7782 23/01/82 1300 1300 10

7788 SCOTT ANALYST 7566 19/04/87 3000 3000 20

NO NAME JOB MANAGER HIREDATE SALARY COMM TOTAL number of job

--------- ---------- --------- ---------- -------- ---------- ---------- ---------- -------------

7369 SMITH CLERK 7902 17/12/80 800 800 20

7844 TURNER SALESMAN 7698 08/09/81 1500 0 1500 30

7521 WARD SALESMAN 7698 22/02/81 1250 500 1750 30

جميل باللغة العربية الناتج يطلع جداً ملخبط

ÇáÑÞã ÇáÇÓã ÇáæÖíÝÉ ÇáãÏíÑ ÇáÊÚíä ÇáÑÇÊÈ ÇáÇÖÇÝÉ ÇáãÌãæÚ ÑÞã ÇáæÖíÝÉ

--------- ---------- --------- ---------- -------- ---------- ---------- ---------- -----------

7876 ADAMS CLERK 7788 23/05/87 1100 1100 20

7499 ALLEN SALESMAN 7698 20/02/81 1600 300 1900 30

7698 BLAKE MANAGER 7839 01/05/81 2850 2850 30

7782 CLARK MANAGER 7839 09/06/81 2450 2450 10

7902 FORD ANALYST 7566 03/12/81 3000 3000 20

7900 JAMES CLERK 7698 03/12/81 950 950 30

7566 JONES MANAGER 7839 02/04/81 2975 2975 20

7839 KING PRESIDENT 17/11/81 5000 5000 10

7654 MARTIN SALESMAN 7698 28/09/81 1250 1400 2650 30

7934 MILLER CLERK 7782 23/01/82 1300 1300 10

7788 SCOTT ANALYST 7566 19/04/87 3000 3000 20

ÇáÑÞã ÇáÇÓã ÇáæÖíÝÉ ÇáãÏíÑ ÇáÊÚíä ÇáÑÇÊÈ ÇáÇÖÇÝÉ ÇáãÌãæÚ ÑÞã ÇáæÖíÝÉ

--------- ---------- --------- ---------- -------- ---------- ---------- ---------- -----------

7369 SMITH CLERK 7902 17/12/80 800 800 20

7844 TURNER SALESMAN 7698 08/09/81 1500 0 1500 30

7521 WARD SALESMAN 7698 22/02/81 1250 500 1750 30

شكراً لكم