On Jul 15, 11:15 am, Spero <[email protected]> wrote:
> I am missing somthing very stupid here, but how do I the below to work
> in Oracle enviornment?
>
> DECLARE @Var1 INT
> DECLARE @Var2 INT
> SET @Var1 = 1
> SET @Var2 = 2
> SELECT @Var1 'Var1', @Var2 'Var2'
SQL> var var1 number
SQL> var var2 number
SQL> exec :var1 := 1; :var2:=2;
PL/SQL procedure successfully completed.
SQL> select :var1 "Var1", :var2 "Var2" from dual;
Var1 Var2
---------- ----------
1 2
SQL>
David Fitzjarrell
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
