PLS-00103：在预期以下情况之一时遇到符号“文件名”：

Question

我正在运行以下脚本-

BEGIN
    select department_name 
    from egpl_department 
    where department_id in (select department_id 
                            from egpl_casemgmt_activity);
END ;

并得到了错误-

PLS-00103: Encountered the symbol "end-of-file" when 
expecting one of the following: 
;

Answer 1

在PL / SQL块中，select语句应包含一个into子句：

DECLARE
 v_department egpl_department.department_name%type;
BEGIN 
  select department_name 
  into   v_department
  from   egpl_department 
  where  department_id in (select department_id from egpl_casemgmt_activity);

  -- Do something useful with v_department
END;