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

Explain the difference between sql and oracle?

17. Display the order number and average item cost for each order.

What is a data segment ?

What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?

Give syntax for SQL and ORACLE joins.

Explain compound trigger in oracle?

How you open and close a cursor variable.Why it is required?

Why does oracle 9i treat an empty string as null?

What is an oracle database table?

How to create a single index for multiple columns?

How to shutdown your 10g xe server from command line?

What is the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN?

For more Oracle General Interview Questions Click Here