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

State some uses of redo log files?

981

---

How to grant create session privilege to a user in oracle?

975

---

Name the three major set of files on disk that compose a database in Oracle?

1100

---

What is a database table in oracle?

1000

---

How many data types are supported?

1065

---

How to use null as conditions in oracle?

1053

---

What is the difference between translate and replace?

1047

---

Explain the use of control file?

1093

---

How to omit columns with default values in insert statement in oracle?

1035

---

How to retrieve values from data fields in record variables?

1087

---

What is coalesce function?

1052

---

How to speed up webrick?

1053

---

How many types of tables supported by oracle?

1056

---

How to check database size in Oracle?

1170

---

What is procedure overloading in oracle?

1031

---