Posted By

bbrumm on 02/28/17


Tagged

sql Oracle


Versions (?)

Oracle LOWER Function


 / Published in: SQL
 

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

A few examples of the LOWER function.

  1. --LOWER
  2.  
  3. --Example 1
  4. SELECT LOWER('Saturday')
  5. FROM dual;
  6.  
  7.  
  8. --Example 2
  9. SELECT LOWER('The city of Houston 2468')
  10. FROM dual;
  11.  
  12.  
  13. --Example 3
  14. SELECT LOWER('ENGLAND')
  15. FROM dual;
  16.  
  17.  
  18. --Example 4
  19. SELECT
  20. first_name,
  21. LOWER(first_name)
  22. FROM customers;

Report this snippet  

You need to login to post a comment.