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 are a cluster and non-cluster index?

1018

What are a collation and state the different types of collation sensitivity?

1170

Can objects of the same schema reside in different tablespace?

1062

How do I escape a reserved word in oracle?

1199

How to establish administrator authentication to the server?

1043

What are ddl statements in oracle?

1075

How do I limit the number of rows returned by an oracle query after ordering?

1170

What do you mean by merge in oracle?

996

What is the max number of columns in an oracle table?

1001

How do you store pictures in a database?

1007

Give the various exception types.

993

What is the data pump import utility?

1035

Can we store images in oracle database?

1010

How to do paging with oracle?

999

What is the difference between alert log file and tarce file ?

2172