Answer Posted / sukanya

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

Can objects of the same schema reside in different tablespace?

584

---

What are the different types of trigger and explain its various uses and functions?

547

---

How to check database size in Oracle?

637

---

How do I use os authentication with weblogic jdriver for oracle and connection pools?

573

---

What is a table in oracle?

541

---

---

How to create an oracle database?

582

---

How to start an oracle instance?

572

---

How will you differentiate between varchar & varchar2?

587

---

How do I limit the number of oracle database connections generated by weblogic server?

543

---

Explain the use of grant option in imp command.

576

---

What are the limitations oracle database 10g xe?

569

---

Explain the use of Merge statement in oracle 11g

592

---

What is an Oracle index?

1175

---

what is the use of system.effective.date variable in oracle?

671

---

How can I combine multiple rows into a comma-delimited list in oracle?

578

---