概述
我正在使用Oracle sql Developer编写代码.我有一个简单的选择语句工作：
SELECT
CFS.CAE_SEC_ID,CFS.FM_SEC_CODE,CFS.LAST_USER_ID,case
when 1 = 1 then
sl.usbank_to_edit
else
case
when 'ENTCB174' = CFS.last_user_id then
sl.owner_to_edit
else
sl.to_edit
end
end canEdit
FROM
CAEDBO.CAE_FOF_SECURITY CFS
INNER JOIN caedbo.CAE_DATA_SET_ELEMENT CDSE_STAT
ON (CDSE_STAT.DATA_SET_ELEMENT_ID = CFS.APPR_STATUS)
INNER JOIN caedbo.CAE_STATE_LOOKUP sl
ON (sl.object_state = CDSE_STAT.data_set_element_id)
where
cfs.CAE_SEC_ID in (3741,3744,3748,3752);
然而,我想添加一些变量,并引用语句中的变量,类似于下面,并在代码窗口中运行它.如何正确执行？
DECLARE
p_USBank_n NUMBER;
p_user_id_c VARCHAR2(20);
BEGIN
p_USBank_n := 1;
p_user_id_c := 'ENTCB174';
SELECT
CFS.CAE_SEC_ID,case
when p_USBank_n = 1 then
sl.usbank_to_edit
else
case
when p_user_id_c = CFS.last_user_id then
sl.owner_to_edit
else
sl.to_edit
end
end canEdit
FROM
CAEDBO.CAE_FOF_SECURITY CFS
INNER JOIN caedbo.CAE_DATA_SET_ELEMENT CDSE_STAT
ON (CDSE_STAT.DATA_SET_ELEMENT_ID = CFS.APPR_STATUS)
INNER JOIN caedbo.CAE_STATE_LOOKUP sl
ON (sl.object_state = CDSE_STAT.data_set_element_id)
where
cfs.CAE_SEC_ID in (3741,3752);
END;
当我在一个sql窗口中运行它,我得到以下消息：
Error report:
ORA-06550: line 8,column 5:
PLS-00428: an INTO clause is expected in this SELECT statement
06550. 00000 - "line %s,column %s:n%s"
*Cause: Usually a PL/sql compilation error.
*Action:
最后
以上就是独特鸵鸟为你收集整理的oracle命令窗口定义变量,在Oracle SQL Developer代码窗口中使用变量运行sql代码的全部内容，希望文章能够帮你解决oracle命令窗口定义变量,在Oracle SQL Developer代码窗口中使用变量运行sql代码所遇到的程序开发问题。
如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。
发表评论 取消回复