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: SQL+ question

Re: SQL+ question

From: Galen Boyer <galen_boyer_at_yahoo.com>
Date: 4 Jun 2006 08:13:03 -0500
Message-ID: <ufyikyjqx.fsf@rcn.com>


On 3 Jun 2006, deanbrown3d_at_yahoo.com wrote:
> It's Saturday evening, and sadly we are still working, so let's keep
> it friendly at least!
>
> The point is to not edit the sql statement (which often comes over as
> a single huge long text line) but to run it by setting the parameters
> for it externally. I know in DNS you can say "using" and list the bind
> variable. What about regular SQL?

There isn't anything that the database gives you as support. I'd start by cutting this to a text file and then building a shell/perl/java script which parsed it to build the SQL+ script. The problem would be getting the datatypes.

If you could get the datatypes, then the shell/perl/java script could run the thing for you as well.

-- 
Galen Boyer
Received on Sun Jun 04 2006 - 08:13:03 CDT

Original text of this message

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