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 |
Does rowid change in oracle?
Is it possible to split the print reviewer into more than one region ?
How to put more than 1000 values into an oracle in clause?
What is the disadvantage of User defind function?
How will you differentiate between varchar & varchar2?
How can we find out the current date and time in oracle?
What is the difference between postgresql and oracle?
1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]
How to connect to the server with user account: sys?
when do u go for hash partitioning?
What are the Limitations of a CHECK Constraint ?
Explain how you would restore a database using RMAN to Point in Time?