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

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

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

Post New Answer

More Oracle General Interview Questions

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers

I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.

3 Answers Microsoft,

What is Library Cache in Oracle?

0 Answers MCN Solutions,

What is autonomous transaction?

6 Answers

Indexes in oracle ?

3 Answers Keane India Ltd, L&T,

how to retrieve data from different tables ,place this data in different excel worksheets.

1 Answers Gap Inc,

What is snapshot is too old? Give and example for better understand.

0 Answers TCS,

What is a subquery in oracle?

0 Answers

ABOUT IDENTITY?

0 Answers HCL,

What is a Segment ?

1 Answers

what are the advantages of running a database in archive log mode?

0 Answers

What is cluster Key ?

3 Answers

For more Oracle General Interview Questions Click Here