Answer Posted / samir kumar sahoo

SELECT DISTINCT salary FROM (SELECT DISTINCT salary,ROWNUM
rn FROM employee ORDER BY salary desc) WHERE rn=1;

What is pragma autonomous transaction in oracle?

993

---

What's dateware house and what's clustor with practicle example

2128

---

How to write text literals in oracle?

1021

---

What are the uses of Database Trigger ?

1625

---

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2260

---

What is rich query?

929

---

Why do you use stored procedures and state some of its disadvantages?

971

---

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

950

---

Explain the different normalization forms?

1012

---

Briefly explain what is literal? Give an example where it can be used?

975

---

Is there any function in oracle similar like group_concat of mysql?

989

---

What is the difference between truncate & delete command?

1125

---

Explain an index?

1095

---

Explain the difference between a procedure and a function? What do you understand by those terms?

1023

---

Explain the difference between sql and oracle?

1026

---