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
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)
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
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Sorry,
I will not download just any document posted here. Read the sticky (tips and tricks) and try again.

MHE
Re: Connect by help [message #213045 is a reply to message #213020] Tue, 09 January 2007 03:55 Go to previous message
JRowbottom
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 Feb 06 13:18:42 CST 2025