Connect by help [message #213019] |
Tue, 09 January 2007 02:47  |
harpreetsinghkup
Messages: 52 Registered: May 2006 Location: Mumbai
|
Member |
|
|
Respected Experts,
i have a query for all of you.
based on most popular table
i am using oracle 9i rel 2
select level,substr(lpad(' ',(level-1)*4,' ')||ename,1,30) ename
,sal,substr(sys_connect_by_path(sal,'.'),1,50) sal_path
from emp
start with mgr is null
connect by prior empno=mgr;
This query is return me values just like as a uploaded file.
but i want a result form the query as my expected_sal column
For more information please see uploaded file..
please help me for this.
Thanks in advance.
-
Attachment: a.doc
(Size: 25.50KB, Downloaded 496 times)
|
|
|
|
|