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 |
What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
How to handle a single quote in oracle sql?
What happens if variable names collide with table/column names?
How is it different from a normal table?
What is the parameter mode that can be passed to a procedure?
Why is oracle so popular?
how to tune oracle sql queries pls tell me step by step. urgent pls
How to create lov dynamically at runtime & attach to text field?
write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"
What is the maximum limit on the number of columns in a table?
What is a read write transaction in oracle?