I am trying to indent a scroll-thru menu which has been made into a tree using the
following database query:
select dept_id, LPAD(' ',2*(Level-1))||dept_name dept_name
from depts
start with dept_id = 1
connect by dept_parent = PRIOR dept_id;
My problem is that the query uses spaces to ind
return $line;
}
Rob
-Original Message-
From: Kristin A. I. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 12:39 PM
To: [EMAIL PROTECTED]
Subject: Search & Replace Issue
I am trying to indent a scroll-thru menu which has been made into a tree
using the following datab
On Tuesday, April 9, 2002, at 09:39 AM, Kristin A. I. wrote:
> I am trying to indent a scroll-thru menu which has been made into a tree
> using the following database query:
> select dept_id, LPAD(' ',2*(Level-1))||dept_name dept_name
> from depts
> start with dept_id = 1
> connect by
"Kristin A. I." wrote:
>
> I am trying to indent a scroll-thru menu which has been made
> into a tree using the following database query:
> select dept_id, LPAD(' ',2*(Level-1))||dept_name dept_name
> from depts
> start with dept_id = 1
> connect by dept_parent = PRIOR dept_id;
> My probl