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

Home -> Community -> Usenet -> c.d.o.server -> Re: calculating variables in sql script

Re: calculating variables in sql script

From: <samir.vds_at_googlemail.com>
Date: 24 Mar 2007 04:01:58 -0700
Message-ID: <1174734118.635167.320830@p15g2000hsd.googlegroups.com>


On Mar 23, 4:31 pm, DA Morgan <damor..._at_psoug.org> wrote:
> Vince wrote:
> > On Mar 22, 10:20 am, "samir...._at_googlemail.com"
> > <samir...._at_googlemail.com> wrote:
> >> On Mar 22, 5:17 pm, Jeremy <jeremy0..._at_gmail.com> wrote:
>
> >>> In article <1174572917.751479.55..._at_o5g2000hsb.googlegroups.com>,
> >>> samir...._at_googlemail.com says...
> >>>> On 22 Mrz., 14:38, "sybrandb" <sybra..._at_gmail.com> wrote:
> >>>>> On Mar 22, 2:17 pm, "samir...._at_googlemail.com"
> >>>>>> Ok, Pl/SQL is a propertary language, which I don't like so very much.
> >>>>>> Are there any useable alternatives?- Hide quoted text -
> >>>>>> - Show quoted text -
> >>>>> You are showing a SQL script. Has nothing to do with PL/SQL.
> >>>>> If you don't like Sql*plus, dump Oracle and replace it by a toy like
> >>>>> MySQL.
> >>>> I know my script has nothing to do with PL/SQL (it's plain SQL).
> >>>> However, Hpuxrac suggested using PL/SQL for my intention and that's
> >>>> what I was reffering to ...
> >>> Well this *is* an Oracle database newsgroup and you *did* ask:
> >>>> If that is so, is there some other scripting/programming language
> >>>> available in which I can accomplish this?
> >>> So I reckon you got a pretty good answer.
> >>> --
> >>> jeremy
> >> Yeah, I got that. It's just that I'd prefer a free alternative to PL/
> >> SQL.
> >> Anyway, don't mind ...- Hide quoted text -
>
> >> - Show quoted text -
>
> > I think you would have to go back years in order to have a version of
> > Oracle that did not automatically have PL/SQL.
>
> > Try this from your SQL prompt:
>
> > SQL> set serveroutput on
> > SQL> begin
> > 2 dbms_output.put_line('This is my first PL/SQL program');
> > 3 end;
> > 4 /
>
> > If you dont get an error, you have PL/SQL.
>
> All the way back to 6.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Just for the info for you guys. I finally decided to realize the work in Python. Received on Sat Mar 24 2007 - 06:01:58 CDT

Original text of this message

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