Answer Posted / nishi

select level, min('col_name') from my_table where level = '&n' connect by prior

('col_name') <'col_name') group by level;

Example:

Given a table called emp with the following columns:

-- id number

-- name varchar2(20)

-- sal number

--

-- For the second lowest salary:

-- select level, min(sal) from emp

-- where level=2

-- connect by prior sal < sal

-- group by lev

What is meant by joins? List out the types of joins.

957

---

how do u setup a replication site?

1918

---

Explain the use of online redo log files in oracle.

991

---

Who developed oracle & when?

944

---

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2503

---

1) Does oracle have any table which contain all the exceptions and it's code internally?

1696

---

What do database buffers contain?

958

---

How to drop a stored procedure in oracle?

996

---

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2245

---

Can sub procedure/function be called recursively?

945

---

How can we view last record added to a table?

970

---

What is a database schema in oracle?

1054

---

How to update values in a table in oracle?

958

---

How are extents allocated to a segment?

1061

---

How to define an oracle sub procedure?

1054

---