可以先做判斷的 select count(*) into i from Rl_da_EmployeeInfo where EmployeeID=v_SalesID; if i > 0 then select nvl(EmployeeName,'未知'), nvl(Department, '未知') into v_EmployeeName, v_DepartmentID from Rl_da_EmployeeInfo where EmployeeID=v_SalesID; elsif i = 0 then goto xxx end if ..... <<xxx>>
select nvl(max(EmployeeName),'未知'), nvl(max(Department), '未知') into v_EmployeeName, v_DepartmentID from Rl_da_EmployeeInfo where EmployeeID=v_SalesID;
select count(*) into i
from Rl_da_EmployeeInfo where EmployeeID=v_SalesID;
if i > 0 then
select nvl(EmployeeName,'未知'), nvl(Department, '未知')
into v_EmployeeName, v_DepartmentID
from Rl_da_EmployeeInfo
where EmployeeID=v_SalesID;
elsif i = 0 then
goto xxx
end if
.....
<<xxx>>