Re: Tree menu with pl/sql and html
From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Sun, 10 Apr 2005 08:21:23 -0400
Message-ID: <WbGdnaKhuq_bh8TfRVn-vw_at_comcast.com>
>> "Simo" <yuppie_at_interfree.it> wrote in message
>> news:f482699.0504082316.1b7f99ce_at_posting.google.com...
>> > Hi!
>> > Does anybody have implemented an html tree with hierarchy query in
>> > pl/sql
>> > language?
>> > I have the right query but i can't show it on html...
>> >
>> > Thanks a lot,
>> > Simona
>>
>> pl/sql web toolkit or HTMLDB?
>>
>> this probably boils down to a DHTML question...
>>
>> ++ mcs
Date: Sun, 10 Apr 2005 08:21:23 -0400
Message-ID: <WbGdnaKhuq_bh8TfRVn-vw_at_comcast.com>
"Simo" <yuppie_at_interfree.it> wrote in message news:f482699.0504100352.6eee711b_at_posting.google.com...
> "Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message > news:<q62dnXux_JiyJMrfRVn-3Q_at_comcast.com>...
>> "Simo" <yuppie_at_interfree.it> wrote in message
>> news:f482699.0504082316.1b7f99ce_at_posting.google.com...
>> > Hi!
>> > Does anybody have implemented an html tree with hierarchy query in
>> > pl/sql
>> > language?
>> > I have the right query but i can't show it on html...
>> >
>> > Thanks a lot,
>> > Simona
>>
>> pl/sql web toolkit or HTMLDB?
>>
>> this probably boils down to a DHTML question...
>>
>> ++ mcs
> > Pl/sql web toolkit i mean.... > > bye > simona
what type of functionality in the browser are you looking for? do you need the hierarchy to be dynamic in any way (links, expand/collapse)? how familiar are you with DHTML?
basically, you're going to loop though your records and issue the appropriate DHTML tags via htp.p... here's an easy way:
create or replace procedure tree_query
as
begin
htp.p('<p>Tree Query Sample</p>');
- start HTML table -- htp.p('<table>');
- loop thru hierarchical query
--
for r1 in (
select level, ename, job, empno
from emp
connect by prior empno = mgr
start with mgr is null
)
loop
- start HTML table row -- htp.p('<tr>');
- generate empty cells for indent -- for i in 2..r1.level loop htp.p('<td width=15> </td>'); end loop;
- output row data in the final cell; use colspan so data cell is not aligned with indent cells -- htp.p('<td colspan=100>' || r1.ename || ' (' || r1.empno || ') ' || r1.job || '</td>');
- end HTML row
--
htp.p('</tr>');
end loop;
- end HTML table -- htp.p('</table>'); end tree_query;
++ mcs Received on Sun Apr 10 2005 - 14:21:23 CEST