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

How to resolve name conflicts between variables and columns?

1035

---

How many types of database triggers exist?

1141

---

How to apply filtering criteria at group level in oracle?

1045

---

Can we store images in oracle database?

1013

---

When do I need to use a semicolon vs a slash in oracle sql?

1091

---

Explain oracle data types with examples?

1035

---

What are nested tables?

1178

---

What is literal?

1015

---

Briefly explain what is literal? Give an example where it can be used?

1045

---

Can group functions be mixed with non-group selection fields?

1025

---

What is bulk load in oracle?

1076

---

What do you mean by merge in oracle?

997

---

Describe an oracle table?

1056

---

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2970

---

what is the scripts in data base?

2160

---