pls explain connect by prior with example and its real time
use
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 This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
Explain about integrity constraint?
What is object data modeling?
Explain an exception and its types?
How to select some columns from a table in oracle?
How to load excel data sheet to oracle database
Explain the use of inctype option in exp command.
Can you drop an index associated with a unique or primary key constraint?
What are the advantages of oracle?
 How to use an oracle sequence generator in a mapping?
What is transport network substrate (tns) in oracle?
What are the limitations oracle database 10g xe?
What are the differences between primary key and unique key?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
What are the roles of dba?