Use function Lower and upper select lower(ename), upper(ename) from emp;

12. Display the client name in upper case only and in lower
case only.

Question Posted / devraj

Answer Posted / devraj

Use function Lower and upper

select lower(ename), upper(ename) from emp;

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a relational database management system?

1102

How many data types are supported?

1067

How to assign a table row to a record variable?

1010

How to connect the oracle server as sysdba?

1063

What is an oracle transaction?

1113

What is raw datatype in oracle?

1115

Explain what are the type of synonyms?

1094

Difference between oracle's plus (+) notation and ansi join notation?

1082

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1017

Explain the use of indexes option in exp command.

1120

How to convert character types to numeric types?

1097

What are the different oracle database objects?

1076

Â What are the oracle DML commands possible through an update strategy?

1042

Can we write insert statement in function in oracle?

1070

How to define a data source name (dsn) in odbc manager?

1009