如果Elsif有什么问题？

Question

    DECLARE DBName VARCHAR(100); ApplicationURL VARCHAR(100);

BEGIN
select NAME into DBName FROM v$database;  

  IF DBName = 'WAMDEV' THEN ApplicationURL := 'http://srpwam10:9080/maximo';
      ELSIF  DBName ='WAMDEVPJ' THEN ApplicationURL := 'http://srpwam10:9080/maximo';
      ELSIF  DBName = 'WAMTST' THEN ApplicationURL := 'http://wamtest/maximo'
      ELSIF  DBName = 'WAMTSTPJ' THEN ApplicationURL := 'http://wamtest/maximo'
      ELSIF  DBName = 'WAMQA' THEN ApplicationURL := 'http://wamqa/maximo'
      ELSIF  DBName = 'WAMQAPJ'  THEN ApplicationURL := 'http://wamqa/maximo'
      ELSE  DBName = 'WAMP' THEN ApplicationURL := 'http://wam/maximo'
    END IF ;
    DBMS_OUTPUT.PUT_LINE(ApplicationURL)
    END

它给出了错误:ORA-06550:第9行，第7列:PLS-00103:在期望下列之一时遇到了符号“elsif”：

• &=-+；in是mod余数而不是rem<>或！=或~=>=<=<>和或类似于2类似于4类似于multiset成员子multiset之间
  1. 00000-“行%s，列%s:\n%s”*原因：通常是PL/SQL编译错误。

Answer 1

添加了你丢失的分号

DECLARE
  DBNAME         VARCHAR(100);
  APPLICATIONURL VARCHAR(100);

BEGIN
  SELECT NAME INTO DBNAME FROM V$DATABASE;

  IF DBNAME = 'WAMDEV' THEN
    APPLICATIONURL := 'http://srpwam10:9080/maximo';
  ELSIF DBNAME = 'WAMDEVPJ' THEN
    APPLICATIONURL := 'http://srpwam10:9080/maximo';
  ELSIF DBNAME = 'WAMTST' THEN
    APPLICATIONURL := 'http://wamtest/maximo';
  ELSIF DBNAME = 'WAMTSTPJ' THEN
    APPLICATIONURL := 'http://wamtest/maximo';
  ELSIF DBNAME = 'WAMQA' THEN
    APPLICATIONURL := 'http://wamqa/maximo';
  ELSIF DBNAME = 'WAMQAPJ' THEN
    APPLICATIONURL := 'http://wamqa/maximo';
  ELSE
    DBNAME := 'WAMP';
    APPLICATIONURL := 'http://wam/maximo';
  END IF;
  DBMS_OUTPUT.PUT_LINE(APPLICATIONURL);
END;

也可以使用案例陈述，在一些人看来，这是一种更干净的外观。