Answer Posted / guest

select max(sal) from Table
where sal not in(select max(sal) from Table);

How do you bind variables in oracle?

931

---

What are ddl statements in oracle?

1018

---

How to get execution path reports on query statements?

929

---

What is a proxy object?

1011

---

What is clustered table in Oracle?

1108

---

What is recovery manager(rman) backup in Oracle?

1127

---

Can we store pictures in the database and if so, how it can be done?

985

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

974

---

How to synchronize 2 schema's objects?

2117

---

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2075

---

What is the difference between Delete, Truncate and Drop in Oracle?

1067

---

Explain integrity constraint?

1109

---

What privilege is needed for a user to delete rows from tables in another schema?

1020

---

What happens if the imported table already exists?

974

---

What is the implicit cursor in oracle?

1039

---