Loading Into Random Table

[vikram solanki]

Hi All,

I am stuck with a small problem here. This may even sound a little crazy but here it is...
I am trying to load some data into tables. I have the tables created and the data available in an xml. I even have a xml parser that gets me the data from the xml. But the problem is i do not know which coulmn may be present in which table. So is there any way
1. I could load the data into the database with only the column names? (please note that all the tables will have uniqe column names. None of the coulmns will be repeated.)
2. I could find the name of the table in which the column is present and then load the data into the DB.

Please let me know if you have any ideas
Thanks

[Jeanne Boyarsky]

You could use ResultSetMetaData to learn about the columns. Or in some databases, such as Oracle, you can query another table to see which columns exist.