Oracle SQL in 10 Minutes - Asim Abbasi
CH1: SQL Basics | CH2: SQL Operators | CH3: SQL Built-in Functions | CH4: SQL Joins | CH5: UPDATE, INSERT & DELETE Statements | CH6: CREATE, ALTER & DROP Statements | CH7: Constraints | CH8: Linking Tables vs Joining Tables | CH9: SQL Statements for Other Database Objects | CH10: SQL Statements for Database Security
Chapter 3: SQL Built-in Functions
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
Chapter 3: SQL Built-in Functions
CH1: SQL Basics | CH2:
SQL Operators |
CH3: SQL Built-in Functions | CH4:
SQL Joins | CH5:
UPDATE, INSERT & DELETE Statements |
CH6: CREATE, ALTER & DROP Statements | CH7:
Constraints | CH8:
Linking Tables vs Joining Tables | CH9:
SQL
Statements for Other Database Objects | CH10:
SQL Statements for
Database Security Share with others: