Usenet.com

www.Usenet.com

Group Index

Comp Thread Archive from Usenet.com

<-- __Chronological__ --> <-- __Thread__ -->

Re: PL/SQL DECLARE



Rekha???? kabhe ainey me moon dekha???

"Rekha" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi
> I am new to PL/SQL and I am learning it using online tutorials.
> All the tutorials say that I should have a DECLARE statement to
> declare my variables but when i try to compile it fails at the declare
> statement
> I am using oracle 9i and Toad to connect to the database.
> This is a simple code i found on web but it doesnt work
> -----------------------------------------------------------------------
> declare
>          a number;
>          b number;
>          c number;
> begin
>          a:=&a;
>          b:=&b;
>          c:=a+b;
>          dbms_output.put_line('Sum of ' || a || ' and ' || b || ' is '
> || c);
>
> end;
> --------------------------------------------------------------------------
-
>
> any help is appriciated
> Reka





<-- __Chronological__ --> <-- __Thread__ -->


Usenet.com



Please check out one of the premium Usenet Newsgroup Service Providers below for access to Usenet.