Sponsored Links
Oracle LAST_DAY function ,Oracle LEAST , Oracle LENGTH
Oracle LAST_DAY(date) Returns the last day of month in Date
select LAST_DAY('08-MAR-08') from dual
result : 31-MAR-08
select LAST_DAY('01-FEB-08') from dual
result : 29-FEB-08
LEAST(expression, expression...)
Returns the smallest in a list of expressions
select LEAST(8,4,45) from dual
result : 4
select LEAST('R','T','A') from dual
result : A
LENGTH(char) Returns the number of characters in char
select LENGTH('asdsasd') from dual
select LENGTH('Earn Money') from dual
result : 10
Page 1
|
| 
