Answer / anil kumar karasi

sql>Select rownum,rownid,level,empno,ename from emp
connect by prior empno=mgr where mgr is null;

o/p
Rownum Rowid Level empno ename
------ ----- ----- ----- -----
1 AABBBCCDA 1 5678 abcd
2 AABBBCCDB 1 9087 poiu
3 AABBBCCDC 2 8567 QWER
4 AABBBCCDD 2 7321 LKJH
5 AABBBCCDE 3 1284 ZXCV

For more details go through this link
http://www.psoug.org/reference/connectby.html

Answer / muhammed zaheer

Connect by prior can be used to create heirarchical tree
structure

Answer / simi

CONNECT BY PRIOR is used for tree-structured queries.
I found a simple & useful explanation here:
http://www.oraclepassport.com
SQL - CONNECT By PRIOR Section

What is the use of file param in imp command?

0 Answers  

---

Difference between join and a subquery?

8 Answers   Base Automation, NMDC,

---

1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]

2 Answers  

---

What is the minimum client footprint required to connect c# to an oracle database?

0 Answers  

---

One Table having two rows with one colomn having values Like"Male" and "Female". how to upadte these values Like "Female" and "Male" in single update statement.

6 Answers   Polaris,

---

Explain oracle’s server parameter file.

0 Answers  

---

What is truncate oracle?

0 Answers  

---

i want department wise maxmum salary and empolyee name

9 Answers  

---

What happens if variable names collide with table/column names?

0 Answers  

---

How to start your 10g xe server?

0 Answers  

---

The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL

1 Answers   TCS,

---

How to set up autotrace for a user account?

0 Answers  

---