Answer Posted / divya

select min(sal) from salarytbl where sal in(select distinct
top 3 sal from salarytbl order by sal desc)

Explain cascading triggers.

1083

---

How to define a variable of a specific record type?

1085

---

What is a dead lock in oracle?

1135

---

What are the different types of modules in oracle forms?

1008

---

How can we force the database to use the user specified rollback segment?

1155

---

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

1870

---

How will you write a query to get a 5th rank student from a table student_report?

1874

---

What are the arithmetic operations?

1092

---

When do I need to use a semicolon vs a slash in oracle sql?

1098

---

When do you get a .pll extension in oracle?

1155

---

What is literal?

1017

---

Can we create trigger on materialized view in oracle?

1001

---

What is the relationship among database, tablespace and data file?

999

---

What is recycle bin in Oracle?

1161

---

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1876

---