Answer Posted / sumeet

select min(sal) from emp where sal in (select top 2 sal from
emp order by sal desc);

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

2043

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

2054

---

What is SQL access advisor in Oracle?

1230

---

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

1134

---

How to install oracle database 10g xe?

1064

---

How to create a table in a specific tablespace?

1027

---

Is oracle an operator?

982

---

Difference between oracle's plus (+) notation and ansi join notation?

1160

---

What is a select query statement in oracle?

1026

---

What is proxy method?

1022

---

Where do you use decode and case statements?

1043

---

How to write a left outer join with the where clause in oracle?

1132

---

What is execute immediate in oracle?

1078

---

What is tns entry?

1236

---

does the query needs a hint to access a materialized view?

1905

---