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
What is the implicit cursor in oracle?
What is a server parameter file in oracle?
What are operators in oracle?
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?
What is the difference between truncate & delete command?
Explain oracle 12c new features for developers?
How do you find current date and time in oracle?
Can we call procedure inside function in oracle?
How to start your 10g xe server from command line?
How to assign a table row to a record variable?
What is a table index in oracle?
How to define a variable to match a table column data type?
How to call a stored function in oracle?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How do I use unicode codesets with the weblogic jdriver for oracle driver?