Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to emulate SQLServer's ( INSERT INTO SELECT FROM .... OPENXML ) functionality in Oracle 9i ???

Re: How to emulate SQLServer's ( INSERT INTO SELECT FROM .... OPENXML ) functionality in Oracle 9i ???

From: Pablo Sanchez <pablo_at_dev.null>
Date: Wed, 12 Mar 2003 17:24:36 -0600
Message-ID: <Xns933CA6EEAA8AApingottpingottbah@216.166.71.233>


"KurtisK" <KJKYLE_at_COOLBLUENOSPAM.COM> wrote in news:gpOba.1461$cG1.590426_at_news1.news.adelphia.net:

> Sure the syntax is different, but we are just replicating the logic from
> T-SQL using PL/SQL syntax.

If you have someone who is proficient in T-SQL and someone (same person?) who is proficient in PL/SQL, then it's relatively straightforward. The logic simply needs to be replicated.

-- 
Pablo Sanchez, High-Performance Database Engineering
http://www.hpdbe.com
Received on Wed Mar 12 2003 - 17:24:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US