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 transaction control statement and how many types of transaction control statement in Oracle?

1101

What are the attributes that are found in a cursor?

1031

Explain the use of rows option in exp command.

1046

What is the data type of dual table?

939

What is oracle in java?

928

various types of hints and their usage

2643

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2323

can u plz provide me oca sql dumps please i need them

1913

How to run queries on external tables?

1001

What is oracle instant client?

986

How to use subqueries with the exists operator in oracle?

986

How to add a new column to an existing table in oracle?

1102

What is a dead lock in oracle?

1064

How to delete a user account in oracle?

928

What are joins, explain all types of joins?

2237