Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Write a query to change the case of strings using lower and upper function

Posted By: Matheus Silva     Category: Oracle     Views: 3575

Write a query to change the case of strings using lower and upper function.

Write a query to change the case of strings using lower and upper function :

SELECT LOWER(NAME),UPPER(NAME) FROM PSTUDENT;

Output : 

LOWER(NAME)      UPPER(NAME)
darshan                     DARSHAN
tushar                        TUSHAR
lokesh                       LOKESH
nirmal                        NIRMAL
mehul                        MEHUL
pritesh                       PRITESH
dhaval                       DHAVAL

  
Share: 

 
 
 


Matheus Silva
Matheus Silva author of Write a query to change the case of strings using lower and upper function is from Salvador, Brazil.
 
View All Articles

Related Articles and Code:


 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!