Number Functions. Review. single-row character functions character case-manipulation functions LOWER, UPPER, INITCAP character-manipulation functions CONCAT, SUBSTR, LENGTH, INSTR LPAD, RPAD TRIM REPLACE. What Will I Learn?. single-row number functions ROUND, TRUNC, and MOD
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
select round(2.55,1) from dual;
m - n * FLOOR(m/n)
FLOOR(n) returns largest integer equal to or less than n.
SELECT last_name, salary
WHERE MOD(salary, 2)=0;