Answer Posted / basanti

delete from employee where salary(select salary from(select
distinct (salary) from employee where salary is NOT NULL
order by salary desc) where rownum=n);

Write a syntax for update query in oracle?

1030

---

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

1077

---

How to unlock the sample user account in oracle?

1010

---

What are the differences between char and varchar2 in oracle?

1165

---

How to get a list of all background sessions in the database?

991

---

Compare and contrast between sql and sql server and explain its various functions?

957

---

Describe the types of sub query?

993

---

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

2305

---

How to delete a user account in oracle?

963

---

What is the difference between count (*), count (expression), count (distinct expression)?

1002

---

How to select some columns from a table in oracle?

1083

---

How can we find out the current date and time in oracle?

1087

---

What are the differences between number and binary_float in oracle?

1098

---

What is meant by joins? List out the types of joins.

1023

---

What is the difference between $oracle_base and $oracle_home?

1083

---