Answer Posted / premsagar12

select max(sal) from emp where sal<(select max(sal) from emp);

Can a formula column be obtained through a select statement ?

2324

---

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2397

---

What happens if variable names collide with table/column names?

1191

---

Can you create a synonym without having a table?

1042

---

List the parts of a database trigger.

1050

---

What is the database name in oracle?

1021

---

How to create a testing table in oracle?

989

---

What are the different types of failures that occur in Oracle database?

1067

---

How to return top 5 rows in oracle?

1062

---

What is a procedure in oracle?

1197

---

How to revoke create session privilege from a user in oracle?

1018

---

Difference between pre-select and pre-query

1109

---

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

1101

---

How to see free space of each tablespace?

1035

---

How can we find out the duplicate values in an oracle table?

1046

---