Use function Lower and upper select lower(ename), upper(ename) from emp;

12. Display the client name in upper case only and in lower
case only.

Question Posted / devraj

Answer Posted / devraj

Use function Lower and upper

select lower(ename), upper(ename) from emp;

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a package in oracle?

1023

Why should I use oracle database?

941

How to import one table back from a dump file?

968

What do you mean by a database transaction & what all tcl statements are available in oracle?

931

How to initialize variables with default values?

1155

What is meant by an index?

1053

How to connect to the server with user account: sys?

968

What is difference between truncate and delete?

972

What is instant client oracle?

972

How to unlock the sample user account in oracle?

915

Explain joins in oracle?

977

What are the differences between char and varchar2 in oracle?

1071

What are named parameters?

1027

How to display employee records who gets more salary than the average salary in the department?

998

How to generate query output in html format?

1030