CHARACTER BUILT IN FUNCTIONS
Jump to navigation
Jump to search
UPPER()
UPPER('john') = JOHN
LOWER()
LOWER('John')=john
LENGTH()
LENGTH('JOHN')=4
SUBSTR()
RETURNS PART OF A STRING
SUBSTR('JAMES',2,3)=AME
DECODE()
RETURNS THE VALUE MATCHING THE CONDITION
DECODE(20,10,'TEN',20,'TWENTY',30,'THIRTY') = TWENTY