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

Why oracle is used?

Oracle

What is system global area (sga) in oracle?

How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?

What is difference between sid and service name in oracle?

What is oracle open database communication (odbc)?

What is the difference between substr and instr?

What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

What are operators in oracle?

What is the quickest way to export a table to a flat file?

What is a dead lock in oracle?

What is a nested table and how is it different from a normal table?

For more Oracle General Interview Questions Click Here