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

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

Question Posted / deepakgunji

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

Answer / devraj

Use function Lower and upper

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

Is This Answer Correct ?

6 Yes

0 No

More Oracle General Interview Questions

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

What is set verify off in oracle?

How to write a query with a full outer join in oracle?

difference between truncate and delete ,drop?

What happens in oracle commit?

Can we store images in oracle database?

How to rebuild an index in oracle?

Explain the use of Merge statement in oracle 11g

Oracle

It's Urgent? How to IMPORT .xls & .txt file into ORACLE?

What are the benefits of ordbms?

Explain the use of indexes option in imp command.

For more Oracle General Interview Questions Click Here