Answer / sharad kumar

select manager name,employee name,level
from table_name
start with manager name is null /* optional*/
connect by prior nocycle employee name = manager name
/*Child = Parent */

Answer / sankar

select manager name,employee name,level from table_name
start with manager_name is null/* optional */ connect by prior
no cycle employee name=manager name/*child=parent*/

what is sp_pkeys? : Transact sql

0 Answers  

---

A table has 150 records. How do you retrieve 100th row to 120th row from that table ?

21 Answers   IBM,

---

Can we use join in subquery?

0 Answers  

---

diff b/w function and procedure?

9 Answers   iFlex,

---

What is parameter substitution in sql?

0 Answers  

---

What are the set operators in sql?

0 Answers  

---

Explain aggregate functions are available there in sql?

0 Answers  

---

How to display the records between two range in Oracle SQL Plus?

0 Answers   MCN Solutions,

---

Write a query to find the employees from EMP table those who have joined in Monday. (there is a column as hiredate which is a date column i.e values are like 03-DEC-81)

5 Answers  

---

Is left join and outer join same?

0 Answers  

---

SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 Answers  

---

What is out parameter used for eventhough return statement can also be used in pl/sql?

0 Answers  

---