Answer / devraj

Use function Lower and upper

select lower(ename), upper(ename) from emp;

write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.

11 Answers   Wipro,

---

How to fetch the row which has the max value for a column?

0 Answers  

---

how to find find & delete duplicate rows from two different tables?

3 Answers   Accenture, TCS,

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

0 Answers  

---

What is meant by recursive hints in oracle?

0 Answers  

---

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

0 Answers   Mastek,

---

What is DTS and purpose of DTS ?

1 Answers   TCS,

---

what is data abstraction

3 Answers   Semantic Space,

---

How to get a create statement for an existing table?

0 Answers  

---

What is the difference between alert log file and tarce file ?

0 Answers   TCS,

---

Can the default values be assigned to actual parameters?

1 Answers  

---

Explain do view contain data?

0 Answers  

---