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 a database table in oracle?
What is a Private Synonyms ?
what is candidate key & super key
Does rowid change in oracle?
How to rename a column in an existing table?
Why do we need integrity constraints in a database?
Hi Guys,I have completed my B.com Commerc in the year 2005 and MBA finance in 2008(Correspondance).And I have 3+yrs exp in Accounting and Finance feild.I have worked for TCS for 1.8yrs as Project manage office as a enduser in oracle ERP module.Currently working as Project Adminstartor for CSC.I have joined in Oracle financial classes and I am through with that subject.So my concern is After learning oracle, am in dilemma that will i be eligible to get job in oracle or not?Please advice or Give me suggestions.To kick start my career as fresher in Oracle
how to insert data into partitioned table partition done by Range partition
Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ?
how to retrieve daily sal from emp table in oracle 10g
Which Oracle App Is Most Popular One ?
What is TNS File