Tutorial66.com
@Share Application Development Skill.



Tutorial is tutorial...66 is My Country Code Up to 10 Years EXP for Application Development Role in Thailand.
collapse

Tutorial Category



« previous next »
Pages: [1]

Topic: Oracle LENGHT,LOWER,UPPER function example for Oracle Text Functions  (Read 157 times)


My Development skill
Java JSP Servlet EJB
Spring Framework
Hibernate Framework
iReport Jasper Report
Apache CXF
PHP Codigniter
Oracle PLSQL
Unix Shell Script
Oracle LENGHT,LOWER,UPPER function example for Oracle Text Functions
« on: December 28, 2011, 07:37:39 AM »
How to use LENGHT function in Oracle PLSQL
Function parameter list

LANGHT(str)  return lenght of str
LOWER(str)   return Lower case of str
UPPER(str)    return Upper case of str

Example code for  LENGHT,LOWER,UPPER
Code: [Select]

SELECT LENGTH('ABCDEF') FROM DUAL  -- return  6
SELECT UPPER('ABCdef') FROM DUAL  -- return  ABCDEF
SELECT LOWER('ABCdef') FROM DUAL  -- return  abcdef



Logged



SimplePortal 2.3.3 © 2008-2010, SimplePortal