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 function and procedure in pl sql?

0 Answers  

---

What is an escape character in sql?

0 Answers  

---

Can a varchar be a primary key?

0 Answers  

---

How insert into statements in sql?

0 Answers  

---

Can we use rowid as primary key?

0 Answers  

---

Can delete statement be rollbacked?

0 Answers  

---

What is pl sql script?

0 Answers  

---

i have a table t1 a math 20 b phy 30 cchemisty 10 a math 40 b phy 23 c che 21 a math15 bphy 33 c che 56 write a quire to find out the max markr of each subject

8 Answers  

---

I want to know the difference between A Record Type and a Table.

3 Answers   Thermotech,

---

Can we use views in stored procedure?

0 Answers  

---

if a table is getting updated what happens if a function is called from sql query?

2 Answers   RBS,

---

What are different types of joins ?

5 Answers   BirlaSoft,

---