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

What are joins..how many types of joins are there?

What is recovery manager in Oracle?

How to see the table columns used in an index?

What are the different oracle database objects?

What is an oracle user account?

what is the syntax of ALTER command?

How to list all tables in your schema?

Explain the use of tables option in exp command.

What is the difference between Outer join and Full outer join?

what is host string in sql plus? how does it related to database?

What is bulk load in oracle?

What privilege is needed for a user to create views in oracle?

For more Oracle General Interview Questions Click Here