Create Variable In Oracle

Question

What is the Oracle equivalent of this MS SQL Server notation?

DECLARE @Variable INT
SET @Variable = 1

FrustratedWithFormsDesigner · Accepted Answer · 2010-04-25 16:21:15Z

4

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.

answered Apr 25, 2010 at 16:21

27.7k31 gold badges151 silver badges211 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pablo Santa Cruz · Accepted Answer · 2010-04-25 16:22:41Z

2

In PL/SQL:

DECLARE
  a number;
BEGIN
  a := 1;
END;

You can paste this code in SQLPlus to run it.

answered Apr 25, 2010 at 16:22

Pablo Santa Cruz

182k33 gold badges250 silver badges300 bronze badges