Oracle LENGTH Function


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

A few examples of the LENGTH function


Copy this code and paste it in your HTML
  1. SELECT LENGTH('Software Developer') AS LENGTH_TEST
  2. FROM dual;
  3.  
  4. SELECT LENGTH('Software Developer ') AS LENGTH_TEST
  5. FROM dual;
  6.  
  7. SELECT country, LENGTH(country) AS COUNTRY_LENGTH
  8. FROM customers;
  9.  
  10. SELECT LENGTH('') AS LENGTH_EMPTY,
  11. LENGTH(' ') AS LENGTH_SPACE
  12. FROM DUAL;

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

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.