Home » Developer & Programmer » Forms » Expandable / Collapsible Menu (Oracle 10g R2 / Win XP)
Expandable / Collapsible Menu [message #331481] Thu, 03 July 2008 09:59 Go to next message
dugjason
Messages: 13
Registered: June 2008
Location: UK
Junior Member
Hi,

I want to create an expandable and collapsible menu (similar to this one on the left side of page for IBM DB2 documentation: http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/c0011568.htm%22)

I know it is possible using technologies like Javascript, but it would be to know if it would be possible to create something similar to this using PL/SQL or something similar.

Not 100% sure if this is the right forum to be posting in, but I hope you can help all the same!
Re: Expandable / Collapsible Menu [message #331486 is a reply to message #331481] Thu, 03 July 2008 10:15 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
PL/SQL has NO interaction with the end-user, so creating a menu in PL/SQL makes no sense.
With PL/SQL however, one can create stuff that is presented to the end-user (for example using htp, or APEX).
Since the functionality of the different options varies so much, we need to know more about your environment. Do you (plan to) use APEX, or something else?

Bottomline _will_ probably be that you need to code it in JS anyway.
Re: Expandable / Collapsible Menu [message #331489 is a reply to message #331486] Thu, 03 July 2008 10:21 Go to previous messageGo to next message
dugjason
Messages: 13
Registered: June 2008
Location: UK
Junior Member
I would be using htp.
I'm still a bit of a beginner, and I don't know what APEX is, or if it is available to me.
I would prefer to stay away from JS, but if it comes to it then I guess I don't really have a choice
Re: Expandable / Collapsible Menu [message #331497 is a reply to message #331489] Thu, 03 July 2008 11:38 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
The main thing htp does is generate html.
If you want dynamic html, you'd have to first see what you want your page(-source!) to look like, and then use the htp-package to generate that..
No fancy stuff in there, as far as I know.
Re: Expandable / Collapsible Menu [message #332922 is a reply to message #331497] Thu, 10 July 2008 02:23 Go to previous messageGo to next message
mudabbir
Messages: 235
Registered: April 2006
Location: Kuwait
Senior Member

As you have raised this topic in the Forms section.

The answer is YES you can by using Oracle Forms. Search for 'Hierarchy Trees' in this section. You will find it.

Best Regards,
Mudabbir
Re: Expandable / Collapsible Menu [message #332926 is a reply to message #332922] Thu, 10 July 2008 02:28 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
But that does not use htp, now does it?
Previous Topic: Syntax to set the property of a block
Next Topic: Calculation without Summary Column
Goto Forum:
  


Current Time: Sun Feb 09 05:53:46 CST 2025