Answer Posted / 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

Is rowid unique in oracle?

978

---

What is oracle data type?

937

---

What is a lookup table in oracle?

962

---

What is Data Dictionary Cache in Oracle?

1143

---

How to open and close an explicit cursor in oracle?

1030

---

How to create additional tablespaces for an new database?

1008

---

What are the attributes of the cursor?

977

---

What are the system predefined user roles?

1025

---

How does one get the view definition of fixed views/tables?

1002

---

How to insert a new row into a table in oracle?

1136

---

Can objects of the same schema reside in different tablespace?

1043

---

Can multiple cursors being opened at the same time?

1050

---

What is the best way to do multi-row insert in oracle?

1048

---

How to load a large xml file?

1031

---

How to drop an existing table in oracle?

1046

---