OraFAQ Forum: SQL & PL/SQL » How to create Tree for Assembly ?

Home » SQL & PL/SQL » SQL & PL/SQL » How to create Tree for Assembly ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to create Tree for Assembly ? [message #354826]

Tue, 21 October 2008 08:04

ranjith_amrita
Messages: 44
Registered: August 2008
Location: Coimbatore

Member

Hi,

How to create htree by getting input from the user???

Is is necessary to insert the data into the database?

I am having two tables namely PartAssembly and Subassembly. This sub assembly comes under the part assembly. So, whenever user enters the values to subassembly it should come under the just previously selected part assembly.

Eg like this

Part Assembly 1
.....Sub assembly 1 a
.....Sub assembly 1 b
.....Sub assembly 1 c
Part Assembly 2
.....Sub assembly 2 a
.....Sub assembly 2 b

How to do this???

[Updated on: Tue, 21 October 2008 08:07]

Report message to a moderator

Re: Tree structure query [message #354829 is a reply to message #354826]

Tue, 21 October 2008 08:35

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Post a test case: create table and insert statements along with the result you want with these data.

Don't hijack a topic with a non related question.

Regards
Michel

Report message to a moderator

Re: Tree structure query [message #354843 is a reply to message #354829]

Tue, 21 October 2008 09:54

ranjith_amrita
Messages: 44
Registered: August 2008
Location: Coimbatore

Member

Hi Sir,

Very sorry. But I dont know how to express my problem other than like this. can you please help me?

Ranjith

Report message to a moderator

Re: Tree structure query [message #354844 is a reply to message #354843]

Tue, 21 October 2008 09:57

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

No until:

Quote:

Post a test case: create table and insert statements along with the result you want with these data.

Regards
Michel

Report message to a moderator

Re: How to create Tree for Assembly ? [message #354994 is a reply to message #354826]

Wed, 22 October 2008 02:54

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

What front end are you planning to insert the data througn?
Forms, SQL*Plus, an Apex web page?

Report message to a moderator

Re: How to create Tree for Assembly ? [message #355695 is a reply to message #354994]

Mon, 27 October 2008 02:04

ranjith_amrita
Messages: 44
Registered: August 2008
Location: Coimbatore

Member

Hi,

Sir, I am using Oracle Developer Suite 10g forms and reports. I want to create tree structure as I mentioned above.

Ranjith

Report message to a moderator

Re: How to create Tree for Assembly ? [message #355701 is a reply to message #354826]

Mon, 27 October 2008 02:23

rajavu
Messages: 11
Registered: March 2005
Location: Bangalore

Junior Member

It doesn't seem to be a comlete question.

well what did you try so far ?

Smile

Rajuvan

Report message to a moderator

Re: How to create Tree for Assembly ? [message #355705 is a reply to message #355695]

Mon, 27 October 2008 03:02

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

ranjith_amrita

I am using Oracle Developer Suite 10g forms and reports.

Does it mean that you'd like to create a tree in your form? If so, we'll move this topic into the Forms forum. Also, use OraFAQ Forum's Search engine as this type of questions have been asked before.

Report message to a moderator

Previous Topic:	Convert Access commands into Oracle
Next Topic:	pl/sql is it object oriented..... newbie question...

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 08 05:48:42 CST 2024