开发者

PL SQL block quoted string not properly terminated

I have written a simple PL SQL block , i am getting this error Please tell me whats the problem in this block ??

declare
a 开发者_StackOverflow社区number:=&a;
b number:=&b;
c number:=&c'
begin
if(a>b) then
DBMS_OUTPUT.PUT_LINE(a);
else
 DBMS_OUTPUT.PUT_LINE(b);
end if;
end;
/


Try (as Codo also said):

DECLARE 
   a NUMBER := &a; 
   b NUMBER := &b; 
   c NUMBER := &c; 
BEGIN 
   IF (a > b) 
   THEN
      DBMS_OUTPUT.PUT_LINE(a); 
   ELSE  
      DBMS_OUTPUT.PUT_LINE(b); 
   END IF; 
END; 
/ 
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜