What is the Oracle equivalent of开发者_StackOverflow社区 this MS SQL Server notation?
DECLARE @Variable INT
SET @Variable = 1
In PL/SQL, you have a declare block:
declare
x integer := 1;
...
begin
...
end;
If you are writing an SQL*Plus script, you use variable
to declare a bind variable
variable x integer := 1;
It's also possible to define variables.
In PL/SQL:
DECLARE
a number;
BEGIN
a := 1;
END;
You can paste this code in SQLPlus to run it.
精彩评论