Oracle INITCAP Function


/ Published in: SQL
Save to your folder(s)

A few examples of the INITCAP function.


Copy this code and paste it in your HTML
  1. --INITCAP
  2.  
  3. --Example 1
  4. SELECT INITCAP('Once upon a time...') AS testvalue
  5. FROM dual;
  6.  
  7.  
  8. --Example 2
  9. SELECT INITCAP('To BE or NOT TO BE') AS testvalue
  10. FROM dual;
  11.  
  12.  
  13. --Example 3
  14. SELECT INITCAP('this is the end') AS testvalue
  15. FROM dual;
  16.  
  17.  
  18. --Example 4
  19. SELECT INITCAP('WHAT IS THE TIME? I DO NOT KNOW') AS testvalue
  20. FROM dual;

URL: http://www.databasestar.com/oracle-initcap/

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.