473,378 Members | 1,138 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

Create ordinary table out of XML Schema

Hi - I searched quite a bit now but still it seems that one topic was
never brought up on oracles xml handling (9i btw). Could anybody tell
me how it is possible to create a table out of a xml schema (I don't
care about the format the xml must have - the important thing is it
being xml)? I can add data to the table using xml, get the schema out
in xml and so on but there seems no topic that handles automatic table
creation using a xml schema (apart from a xmltype).

Best regards
Andreas Bergmeier
Jul 19 '05 #1
2 6162
"Andreas Bergmeier" <an***************@compass-systems.de> wrote in message
news:7a**************************@posting.google.c om...
Hi - I searched quite a bit now but still it seems that one topic was
never brought up on oracles xml handling (9i btw). Could anybody tell
me how it is possible to create a table out of a xml schema (I don't
care about the format the xml must have - the important thing is it
being xml)? I can add data to the table using xml, get the schema out
in xml and so on but there seems no topic that handles automatic table
creation using a xml schema (apart from a xmltype).

Best regards
Andreas Bergmeier


Andreas,

Have you read the article, "Make XML Native and Relative ", by Johnathon
Gennick at http://otn.oracle.com/oramag/oracle/03-jan/o13xml.html ? In that
article, Johnathon takes an XML schema to create object-relational tables.

Douglas Hawthorne
Jul 19 '05 #2
kamal
1
Dear sir i too looking for the same. but on opening http://www.oracle.com/technology/oramag/oracle/03-jan/o13xml.html
above link i am getting following error

Error: You do not have sufficient privileges to perform this operation. (WWC-41415)

kindly tell me the solution
Jul 28 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Phil Powell | last post by:
create table if not exists nnet_produkt_varegruppe ( nnet_produkt_varegruppe_id int not null auto_increment, primary key(nnet_produkt_varegruppe_id), nnet_produkt_varegruppe_navn varchar(255) not...
1
by: vector | last post by:
I want to dynamically create tables in a SQL Server 2000 database that are modelled after XML schemas. I will not know what the schemas might look like until the documents arrive. For example,...
2
by: masri999 | last post by:
I have a requirement in SQL 2005 in Development database 1. Schema dbo owns all objects (tables,views,SPs,UDFs etc) . 2. Only DBA's ( who are database owners ) can create, alter tables ....
1
by: donet programmer | last post by:
I have a requirement where I need to create a dataset that consists of a table inside a table ( a child table inside a parent table). I am not really familiar with the data relations and not sure...
2
by: Amber | last post by:
On my DB2 UDB 8.2.7 database user User1 has been granted IMPLICIT_SCHEMA privilege, but when he issues "create schema test", the error message "SQL0552N, USER1 does not have the previliege to...
3
by: Rahul B | last post by:
Hi, I have a user UCLDEV1 which is a part of staff and a group(db2schemagrp1) to which i have not given any permissions. The authorizations of that user are shown as db2 =get authorizations...
1
by: gdev | last post by:
Having some trouble getting my head around setting access to specific schemas- here's my problem: I've created a specific schema that I only want certain users to control Problem: Even...
1
by: Andreas Bergmeier | last post by:
Hi - I searched quite a bit now but still it seems that one topic was never brought up on oracles xml handling (9i btw). Could anybody tell me how it is possible to create a table out of a xml...
0
debasisdas
by: debasisdas | last post by:
The following script is used to create a read only schema of any existing schema in the same database. The readonly schema is granted only read permisions on the tables and views of the existing...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.