lower case in sql

1select UPPER('converted to upper');
2select LOWER('CONVERTED TO LOWER');

1SELECT upper('Hello World') FROM dual;					-- HELLO WORLD
2SELECT lower('Hello World') FROM dual;					-- hello world
3SELECT inticap('hello world') FROM DUAL; 				-- Hello World

1SELECT UPPER(FIRST_NAME) , LOWER(LAST_NAME)
2FROM CUSTOMERS ;

1LOWER/UPPER
2LOWER wandelt eine String in eine in Kleinbuchstaben um. 
3UPPER ist das Gegenstück zu LOWER, und wandelt den String 
4in Grossbuchstaben um.
5
6SELECT LOWER (expression)
7
8SELECT UPPER (expression)
9

1LOWER(string);