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

Answer Posted / devraj

Use function Lower and upper

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

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the implicit cursor in oracle?

570


What is a server parameter file in oracle?

594


What are operators in oracle?

532


How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

1808


What is the difference between truncate & delete command?

619






Explain oracle 12c new features for developers?

540


How do you find current date and time in oracle?

590


Can we call procedure inside function in oracle?

614


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

549


How to assign a table row to a record variable?

583


What is a table index in oracle?

635


How to define a variable to match a table column data type?

580


How to call a stored function in oracle?

574


what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

1850


How do I use unicode codesets with the weblogic jdriver for oracle driver?

556