Re: Xquery might have some things right
Date: Fri, 5 Mar 2004 10:12:06 -0800
Message-ID: <3z32c.18$zW4.150_at_news.oracle.com>
"Dawn M. Wolthuis" <dwolt_at_tincat-group.com> wrote in message
news:c2aako$f4a$1_at_news.netins.net...
> I agree, with the exception of making it easier to move nested data from
one
> place to another without 1NF-ing if first, XML is just one tiny step up
from
> comma-quote. And comma-quote was just one tiny step up from putting data
in
> various "card columns" (on real or virtual cards).
What is the big deal about moving data from one place to another?
create dblink to RemoteSystemA
insert into LocalTableA
select * from A_at_RemoteSystemA
Unlike my simplistic example, in the real world you have all the power of Relational Algebra & Calculus mix in SQL in order to make required interim data transformations. (Yes, data transformations are relational views, not some goofy stylesheets).
Imagine RemoteSystemA owner provided you with EDI, XML or others ShmackML instead of remote database connection. Suppose all you need to know is how many purchase orders did the system processed last month. Does it mean you have to import *all* the orders to your system first? Received on Fri Mar 05 2004 - 19:12:06 CET