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

How do I call oracle stored procedures that take no parameters?

How to create an oracle database manually?

select * from emp what happened internally when we write this query in the sql prompt?

How to retrieve data from an cursor to a record?

What are the arithmetic operations?

Does rowid change in oracle?

How to do paging with oracle?

What is the parameter mode that can be passed to a procedure?

How can I get column names from a table in oracle?

How to retrieve values from data fields in record variables?

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

how to join query for one source type is oracle another source type is sql server ?

For more Oracle General Interview Questions Click Here