Home » SQL & PL/SQL » Client Tools » Create XML from Master Detail (Toad for Oracle Professional 12.0.0.61)
Create XML from Master Detail [message #662025] Thu, 13 April 2017 02:08 Go to next message
stecas
Messages: 2
Registered: April 2017
Junior Member
Hi all.

Using Toad I want to generate an XML using the Master Detail function.
No problem when the tables are two, but when I add a third table, the feature is disabled.
The button that generates the XML works then only if I have only two tables?

Why?

Is there a way to overcome this problem?

Thanks in advance
Re: Create XML from Master Detail [message #662026 is a reply to message #662025] Thu, 13 April 2017 02:43 Go to previous messageGo to next message
ThomasG
Messages: 3205
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
I don't know Toad, but plain logically "Master / Detail" are only two things. What should the third table become?
Re: Create XML from Master Detail [message #662027 is a reply to message #662026] Thu, 13 April 2017 02:45 Go to previous messageGo to next message
stecas
Messages: 2
Registered: April 2017
Junior Member
I have to create an xml that has a complex hierarchy.
I do not know the Oracle syntax to create them, and I thought that by inserting the XML hierarchy, I could do it with this feature.
Re: Create XML from Master Detail [message #662032 is a reply to message #662027] Thu, 13 April 2017 11:15 Go to previous message
Michel Cadot
Messages: 65208
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
I do not know the Oracle syntax to create them
Oracle has nothing to do with TOAD.

If you post in details and with an example we can execute what you have and what you want maybe we can help.
With such a vague question we can't do anything for you.

Previous Topic: login.sql not running automatically?! Win10
Next Topic: SDCLI : NullPointerException while converting db from Sql Server to Oracle
Goto Forum:
  


Current Time: Fri Nov 24 17:53:09 CST 2017

Total time taken to generate the page: 0.01273 seconds