关于select in和where的简单sql问题
关于select in和where的简单sql问题
提问于 2019-12-19 21:04:25
我怎么能写出这样的函数呢？我在连接clouses时遇到了问题。
create or replace function is_valid_value(valuetoCheck in varchar2)
return varchar2 is
v_value valid_values.resourceName%type;
begin
begin
SELECT RESOURCENAME into v_value
FROM VALID_VALUES
WHERE VALIDVALUE IN (valuetoCheck)
where upper(resourceName) = upper (valuetoCheck);
exception
when no_data_found then
return 0;
end;
return 1;
end is_valid_value ;回答 1
Stack Overflow用户
发布于 2019-12-19 22:32:58
检查此代码。查找内联注释：
create or replace function is_valid_value(
valuetoCheck in varchar2
) return varchar2
is
v_value valid_values.resourceName%type;
begin
--begin --> there is no need for two 'begin' in this case
SELECT RESOURCENAME into v_value
FROM VALID_VALUES
WHERE VALIDVALUE IN (valuetoCheck)
AND /* was WHERE, should be change to AND */ upper(resourceName) = upper (valuetoCheck)
AND other_value = another_value
OR this_value = other_value;
return 1; --> this should be returned before exception
exception
when no_data_found then
return 0;
--end; --> there is no need for end since we removed 'begin'
end is_valid_value;页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/59410371
复制相关文章
相似问题
腾讯云开发者
