Database Reference
In-Depth Information
Other Single Row Functions:
The following functions fall under this category.
NVL
VSIZE
Example:
SELECT ename, NVL(TO_CHAR(COMM), 'NOT
APPLICABLE') "COMMISSION"
FROM emp
WHERE deptno = 30;
Output:
ENAME COMMISSION
---------- -------------------------
ALLEN 300
WARD 500
MARTIN 1400
BLAKE NOT APPLICABLE
TURNER 0
JAMES NOT APPLICABLE
Example:
SELECT ename, VSIZE (ename) "BYTES"
FROM emp
WHERE deptno = 10;
Output:
ENAME BYTES
---------- ----------
CLARK 5
KING 4
MILLER 6
Search WWH ::
Custom Search