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

1 Answers
3935 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / devraj

Use function Lower and upper

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

Is This Answer Correct ?

6 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2269

what is insert all statement in sql

6621

How to run create database statement?

1075

Explain overloading. Can functions be overloaded?

1046

Hi Can any one tell me what are the API's used in requisition import.

1970

What is blob datatype?

1196

What is a system tablespace?

1132

What is a nested table?

1111

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2421

What do you mean by merge in oracle?

1029

Explain the different normalization forms?

1156

What is meant by raw datatype?

1117

What language does oracle use?

1164

Explain mutating triggers.

1088

What are the attributes of the cursor?

1057