LETERALS
LETERALS কি?
ডাটাবেসের অংশ না, কলাম বা রো এর ডাটাও না কিন্তু ডাটাবেসের রো এর সংগে Merge করে Select Command এর সাহায্যে Display করার সয়মে অন্য কলামের সাথে যোগ / লিংক করেও দেখা যায়। Character, Arithmetic Expression ইত্যাদি এভাবে কলামের সাথে লিংক করে দেখা যেতে পারে। Leteral output or return value will display
in each row and treated as a column.
নিচের কমান্ডটি লক্ষ্য করা যাক।
SELECT EMPNO||'-'||ENAME EMPLOYEE, 'WORKS IN
DEPARTMENT # ', DEPTNO
FROM EMP;
EMPLOYEE
'WORKSINDEPARTMENT#' DEPTNO
-------------------------------------------------
----------------- ------------
7369-SMITH Works in
department # 20
7499-ALLEN Works in
department # 30
7521-WARD Works in department # 30
7566-JONES Works in
department # 20
7654-MARTIN Works in
department # 30
7698-BLAKE Works in
department # 30
7782-CLARK Works in
department # 10
7788-SCOTT Works in
department # 20
7839-KING Works in
department # 10
7844-TURNER Works in
department # 30
7876-ADAMS Works in
department # 20
7900-JAMES Works in
department # 30
7902-FORD Works in
department # 20
7934-MILLER Works in department
# 10
14
rows selected.
নিচের কমান্ডটি লক্ষ্য করা যাক।
SQL>SELECT EMPNO||'-'||ENAME EMPLOYEE,
'MONTHLY SALARY IS', SAL
FROM EMP
EMPLOYEE
'MONTHLYSALARYIS' SAL
-----------------------------------------
----------------- ----------
7369-SMITH MONTHLY SALARY
IS 800
7499-ALLEN MONTHLY SALARY
IS 1600
7521-WARD MONTHLY SALARY IS 1250
7566-JONES MONTHLY SALARY
IS 2975
7654-MARTIN MONTHLY SALARY
IS 1250
7698-BLAKE MONTHLY SALARY
IS 2850
7782-CLARK MONTHLY SALARY
IS 2450
7788-SCOTT MONTHLY SALARY
IS 3000
7839-KING MONTHLY SALARY
IS 5000
7844-TURNER MONTHLY SALARY
IS 1500
7876-ADAMS MONTHLY SALARY
IS 1100
7900-JAMES MONTHLY SALARY
IS 950
7902-FORD MONTHLY SALARY
IS 3000
7934-MILLER MONTHLY SALARY IS 1300
নিচের কমান্ডটি লক্ষ্য করা যাক।
SQL> SELECT EMPNO||'-'||ENAME EMPLOYEE,
'YEARLY SALARY IS', SAL*12 + NVL(COMM,0) ANNUL_SALARY
FROM EMP
EMPLOYEE 'YEARLYSALARYIS'
ANNUL_SALARY
---------------------------------------
---------------- ------------
7369-SMITH YEARLY SALARY
IS 9600
7499-ALLEN YEARLY SALARY
IS 19500
7521-WARD YEARLY SALARY
IS 15500
7566-JONES YEARLY SALARY
IS 35700
7654-MARTIN YEARLY SALARY
IS 16400
7698-BLAKE YEARLY SALARY
IS 34200
7782-CLARK YEARLY SALARY IS 29400
7788-SCOTT YEARLY SALARY
IS 36000
7839-KING YEARLY SALARY
IS 60000
7844-TURNER YEARLY SALARY
IS 18000
7876-ADAMS YEARLY SALARY
IS 13200
7900-JAMES YEARLY SALARY
IS 11400
7902-FORD YEARLY SALARY
IS 36000
7934-MILLER YEARLY SALARY
IS 15600
14 rows selected.
কোন মন্তব্য নেই:
একটি মন্তব্য পোস্ট করুন