Re: calculating variables in sql script

On Mar 24, 7:01 am, "samir...._at_googlemail.com" <samir...._at_googlemail.com> wrote:
> 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.

Good for you! Even more non-proprietary way was to use an abacus.

Anurag Received on Sat Mar 24 2007 - 09:43:49 CDT