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 oracle host variable?

1069

---

defination of bitmap index

2132

---

How to view existing locks on the database?

1057

---

Why is oracle database so popular?

1012

---

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

1015

---

How to write date and time literals in oracle?

1003

---

Can you assign multiple query result rows to a variable?

993

---

What is system global area (sga) in oracle?

996

---

Why is oracle so popular?

1005

---

how to handle exceptions in post production

1433

---

What are the data types in oracle?

1044

---

What is a nested table?

1069

---

How to use "startup" command to start default instance?

1041

---

What are the execution control statements in oracle?

1098

---

How to check the server version in oracle?

1095

---