Sponsored Links
Oracle ASCII|Oracle AVG|Oracle CEIL
Oracle ASCII/Oracle AVG/Oracle CEIL
Oracle ASCII(char) function Converts char into a decimal ascii code
select ASCII('A') from dual
Results : 65
even though you insert multiple lerttrs , it will only pick the first letter
eg:
select ASCII('ABC') from dual
Result : 65
Oracle AVG
Oracle AVG([DISTINCT]n) - Averge value of 'n' ignoring NULLs
Oracle CEIL(n)
Round n up to next whole number.
select CEIL(50.3) from dual
Result :
51
select CEIL(50.00001) from dual
Result :
51
Page 1
|
| 
