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

What is the quickest way to export a table to a flat file?

920

---

Explain about functional dependency and its relation with table design?

954

---

What is format trigger?

2016

---

Is there a function to split a string in plsql?

983

---

What is a sub query and what are the different types of subqueries?

1075

---

How to convert characters to times in oracle?

955

---

What is an anonymous block?

1158

---

How to get last row id?

941

---

How to find out what oracle odbc drivers are installed?

979

---

How to run create database statement again?

1079

---

How do I reset a sequence in oracle?

1052

---

What is analyze command used for?

1012

---

Will you be able to store pictures in the database?

1063

---

What are the different types of failures that occur in Oracle database?

1016

---

State all possible different index configurations a table can possibly have?

951

---