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. START FROM THE 2ND POSITION AND RETURN 3 CHARACHTERS
SUBSTR('JAMES',2,3)=AME
DECODE()
RETURNS THE VALUE MATCHING THE CONDITION TAKE THE 20 IN THE FRONT AND RETURN THE CORRESPONDING STRING
DECODE(20,10,'TEN',20,'TWENTY',30,'THIRTY') = TWENTY