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: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 23 Mar 2007 08:31:22 -0700
Message-ID: <1174663880.622257@bubbleator.drizzle.com>


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
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Mar 23 2007 - 10:31:22 CDT

Original text of this message

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