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

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2101

---

What is bulk load in oracle?

1030

---

How to use an explicit cursor without open statements?

1026

---

What are the different editions of oracle?

1073

---

Explain the use of ignore option in imp command.

994

---

Explain about integrity constraint?

1095

---

How to count groups returned with the group by clause in oracle?

1032

---

How can you use check constraints for self referential integrity?

934

---

Explain mutating triggers.

992

---

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1087

---

Explain the use of tables option in exp command.

1077

---

How to find out what oracle odbc drivers are installed?

998

---

How to get a create statement for an existing table?

927

---

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2278

---

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4134

---