Difference between revisions of "CHARACTER BUILT IN FUNCTIONS"
Jump to navigation
Jump to search
(Created page with "==UPPER()== UPPER('john') = JOHN ==LOWER()== LOWER('John')=john ==LENGTH()== LENGTH('JOHN')=4 ==SUBSTR()== '''RETURNS PART OF A STRING''' SUBSTR('JAMES',2,3)=AME ==DECODE...") |
|||
| Line 7: | Line 7: | ||
==SUBSTR()== | ==SUBSTR()== | ||
'''RETURNS PART OF A STRING''' | '''RETURNS PART OF A STRING. START FROM THE 2ND POSITION AND RETURN 3 CHARACHTERS''' | ||
SUBSTR('JAMES',2,3)=AME | SUBSTR('JAMES',2,3)=AME | ||
==DECODE()== | ==DECODE()== | ||
'''RETURNS THE VALUE MATCHING THE CONDITION''' | '''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 | DECODE(20,10,'TEN',20,'TWENTY',30,'THIRTY') = TWENTY | ||
[[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]] | [[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]] | ||
Revision as of 19:26, 5 November 2017
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