Answer Posted / premsagar12

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

Is it possible to insert comments into sql statements return in the data model editor ?

2513

---

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1011

---

What are a collation and state the different types of collation sensitivity?

1098

---

What is tns service name?

1075

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1854

---

What is the difference between pre-select and pre-query?

1126

---

What are the advantages of oracle?

965

---

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

962

---

What are joins, explain all types of joins?

2221

---

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2214

---

How many types of auditing in Oracle?

985

---

Is oracle a language?

902

---

How to define and use table alias names in oracle?

886

---

How to use select statement to count the number of rows in oracle?

993

---

How to create a stored procedure in oracle?

1030

---