Hi Everyone!
Greetings!
Great to have online help through Apex.
I am new to Oracle and would like to practice online. I have found APEX quite useful. Can I run PL/SQL commands on SQL Commands option? I have run a piece of code as follows:
declare
a number(4):=&a;
b number(4):=&b;
c number(5);
begin
c:=a+b;
dbms_output.put_line(c);
end;
I got an error message as below. Can I get guidance for my problem please!
ORA-06550: line 2, column 18: PLS-00103: Encountered the symbol "&" when expecting one of the following: ( - + case mod new not null <an identifier> <a double-quoted delimited-identifier> <a bind variable> continue avg count current exists max min prior sql stddev sum variance execute forall merge time timestamp interval date <a string literal with character set specification> <a number> <a single-quoted SQL string> pipe <an alternatively-quoted string literal with character set specif 1. declare 2. a number(4):=&a; 3. b number(4):=&b; 4. c number(5);