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
Conversion Functions:
The following functions fall under this category
TO_CHAR
TO_DATE
TO_NUMBER
Example:
SELECT TO_CHAR(HIREDATE, 'Month DD, YYYY') "Result"
FROM emp
WHERE ename = 'BLAKE';
Output:
Result
------------------
May 01, 1981
Example:
SELECT TO_CHAR(-10000,'L99G999D99MI') "Result"
FROM DUAL;
Output:
Result
--------------
$10,000.00-
Example:
SELECT TO_DATE('January 15, 1989, 11:00 A.M.',
'Month dd, YYYY, HH:MI A.M.',
'NLS_DATE_LANGUAGE = American')
FROM DUAL;
Example:
SELECT TO_NUMBER('$10,000.00-', 'L99G999D99MI') "Result"
FROM DUAL;
Output:
Result
---------
-1000
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: