Home » SQL & PL/SQL » SQL & PL/SQL » How to create Tree for Assembly ?
How to create Tree for Assembly ? [message #354826] Tue, 21 October 2008 08:04 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Tree structure query [message #354843 is a reply to message #354829] Tue, 21 October 2008 09:54 Go to previous messageGo to next message
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
Re: Tree structure query [message #354844 is a reply to message #354843] Tue, 21 October 2008 09:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: How to create Tree for Assembly ? [message #354994 is a reply to message #354826] Wed, 22 October 2008 02:54 Go to previous messageGo to next message
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?
Re: How to create Tree for Assembly ? [message #355695 is a reply to message #354994] Mon, 27 October 2008 02:04 Go to previous messageGo to next message
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
Re: How to create Tree for Assembly ? [message #355701 is a reply to message #354826] Mon, 27 October 2008 02:23 Go to previous messageGo to next message
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
Re: How to create Tree for Assembly ? [message #355705 is a reply to message #355695] Mon, 27 October 2008 03:02 Go to previous message
Littlefoot
Messages: 20901
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.
Previous Topic: Convert Access commands into Oracle
Next Topic: pl/sql is it object oriented..... newbie question...
Goto Forum:
  


Current Time: Thu Dec 08 18:33:13 CST 2016

Total time taken to generate the page: 0.05917 seconds