Answer / devraj

Use function Lower and upper

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

Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?

1 Answers  

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

---

How to update rows in table, suppose i have lacks of rows in table how to update total table with update statement. Can u please any one answer this question with update statement.

2 Answers  

---

Which is better Oracle or MS SQL? Why?

2 Answers   Bally Technologies,

---

What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)

3 Answers  

---

---

Explain mutating triggers.

0 Answers  

---

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

1 Answers  

---

What is a tns file?

0 Answers  

---

I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????

1 Answers  

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

0 Answers   ESS,

---

Explain alias?

0 Answers  

---

Explain overloading. Can functions be overloaded?

0 Answers  

---