how to declare multiple variables in one line in oracle plsql block

Question

I want to declare multiple variable in one line, Is there any way to write it ?

DECLARE
A integer :=10;
B integer :=5;
BEGIN

END;

i want to declare a and b in one line.

Thanks in Advance,

i have not come across this but it can be done using collection or record datatype — Ashish sinha
– Ashish sinha, Commented Mar 20, 2014 at 8:19
I, for one, would love to see this syntax (seen in some other languages) added to PL/SQL, e.g. a, b, c, d, e integer; although I'm not sure how defaults would work. — Jeffrey Kemp
– Jeffrey Kemp, Commented Mar 24, 2014 at 5:59

Alex Poole · Accepted Answer · 2014-03-20 08:16:14Z

20

No idea why you'd intentionally make your code less readable, but just... put them on one line:

set serveroutput on
DECLARE
  A integer :=10;B integer :=5;
BEGIN
  dbms_output.put_line(a ||':'|| b);
END;
/

anonymous block completed
10:5

The semicolon is a statement separator within PL/SQL and it doesn't matter whether or not you have whitespace or new lines; unlike plain SQL run in SQL*Plus, say, where a new statement after a separator does have to be on a new line, but that's a client thing.

Maybe you mean something else though...

answered Mar 20, 2014 at 8:16

Alex Poole

192k11 gold badges198 silver badges349 bronze badges

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

3 Comments

Adarsh Over a year ago

Thanks for your help, But is there any better way for this ?

Alex Poole Over a year ago

@AdarshPatel - better in what way? Are you asking to define two variables in one statement? That can't be done with scalar variables.

James Daily Over a year ago

I think he was looking for something like this, but for PL/SQL: stackoverflow.com/questions/6202818/…

Rene · Accepted Answer · 2014-03-20 08:16:01Z

6

no, this is the way it works in PLSQL.

answered Mar 20, 2014 at 8:16

Rene

10.6k5 gold badges37 silver badges48 bronze badges

Collectives™ on Stack Overflow

how to declare multiple variables in one line in oracle plsql block

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related