Re: calculating variables in sql script

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. Received on Thu Mar 22 2007 - 21:06:40 CDT