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,
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...
no, this is the way it works in PLSQL.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With