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 |
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
What is set verify off in oracle?
How to write a query with a full outer join in oracle?
difference between truncate and delete ,drop?
What happens in oracle commit?
Can we store images in oracle database?
How to rebuild an index in oracle?
Explain the use of Merge statement in oracle 11g
Oracle
0 Answers ABC, Genpact, HUI, Oracle,
It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
What are the benefits of ordbms?
Explain the use of indexes option in imp command.