Home » SQL & PL/SQL » SQL & PL/SQL » Connect by help
icon2.gif  Connect by help [message #213019] Tue, 09 January 2007 02:47 Go to next message
Messages: 52
Registered: May 2006
Location: Mumbai

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 158 times)
Re: Connect by help [message #213020 is a reply to message #213019] Tue, 09 January 2007 02:52 Go to previous messageGo to next message
Messages: 7062
Registered: December 2001
Senior Member
I will not download just any document posted here. Read the sticky (tips and tricks) and try again.

Re: Connect by help [message #213045 is a reply to message #213020] Tue, 09 January 2007 03:55 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Seeing as you've posted this twice, I'll lock this one.
Previous Topic: after delete trigger
Next Topic: need help
Goto Forum:

Current Time: Thu Jul 27 12:26:08 CDT 2017

Total time taken to generate the page: 0.12045 seconds