Database Reference
In-Depth Information
Output:
Modulus
----------
3
Example:
SELECT SQRT(25) "Square root"
FROM DUAL;
Output:
Square root
-----------
5
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
Search WWH ::




Custom Search