select count(username) from x_ads.registuser where username=v_registuser and gameid=x_ads.f_getgameid(v_gamecode)=1 这条语句作为if条件语句如何拼写组合?if
select count(username) from x_ads.registuser where username=v_registuser and gameid=x_ads.f_getgameid(v_gamecode)=1 then 报错:Compilation errors for PROCEDURE X_ADS.PRO_REGISTUPError: PLS-00103: 出现符号 "SELECT"在需要下列之一时:
( - + case mod new not
null <an identifier> <a double-quoted delimited-identifier>
<a bind variable> continue avg count current exists max min
prior sql stddev sum variance execute forall merge time
timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL string> pipe
<一个带有字符集说明的可带引号的字符串文字>
<一个可带引号的 SQL 字符串> purge
Line: 26
Text: select count(username) from x_ads.registuser where username=v_registuser and gameid=x_ads.f_getgameid(v_gamecode)=1Error: PLS-00103: 出现符号 "="在需要下列之一时:
. ( * % & - + ; / at for mod
remainder rem <an exponent (**)> and or group having
intersect minus order start union where connect || multiset
Line: 26
Text: select count(username) from x_ads.registuser where username=v_registuser and gameid=x_ads.f_getgameid(v_gamecode)=1Compilation errors for PROCEDURE X_ADS.PRO_REGISTUPError: PLS-00103: 出现符号 "SELECT"在需要下列之一时:
( - + case mod new not
null <an identifier> <a double-quoted delimited-identifier>
<a bind variable> continue avg count current exists max min
prior sql stddev sum variance execute forall merge time
timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL string> pipe
<一个带有字符集说明的可带引号的字符串文字>
<一个可带引号的 SQL 字符串> purge
Line: 26
Text: select count(username) from x_ads.registuser where username=v_registuser and gameid=x_ads.f_getgameid(v_gamecode)=1Error: PLS-00103: 出现符号 "="在需要下列之一时:
. ( * % & - + ; / at for mod
remainder rem <an exponent (**)> and or group having
intersect minus order start union where connect || multiset
Line: 26
Text: select count(username) from x_ads.registuser where username=v_registuser and gameid=x_ads.f_getgameid(v_gamecode)=1
select count(username) from x_ads.registuser where username=v_registuser and gameid=x_ads.f_getgameid(v_gamecode)=1 then 报错:Compilation errors for PROCEDURE X_ADS.PRO_REGISTUPError: PLS-00103: 出现符号 "SELECT"在需要下列之一时:
( - + case mod new not
null <an identifier> <a double-quoted delimited-identifier>
<a bind variable> continue avg count current exists max min
prior sql stddev sum variance execute forall merge time
timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL string> pipe
<一个带有字符集说明的可带引号的字符串文字>
<一个可带引号的 SQL 字符串> purge
Line: 26
Text: select count(username) from x_ads.registuser where username=v_registuser and gameid=x_ads.f_getgameid(v_gamecode)=1Error: PLS-00103: 出现符号 "="在需要下列之一时:
. ( * % & - + ; / at for mod
remainder rem <an exponent (**)> and or group having
intersect minus order start union where connect || multiset
Line: 26
Text: select count(username) from x_ads.registuser where username=v_registuser and gameid=x_ads.f_getgameid(v_gamecode)=1Compilation errors for PROCEDURE X_ADS.PRO_REGISTUPError: PLS-00103: 出现符号 "SELECT"在需要下列之一时:
( - + case mod new not
null <an identifier> <a double-quoted delimited-identifier>
<a bind variable> continue avg count current exists max min
prior sql stddev sum variance execute forall merge time
timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL string> pipe
<一个带有字符集说明的可带引号的字符串文字>
<一个可带引号的 SQL 字符串> purge
Line: 26
Text: select count(username) from x_ads.registuser where username=v_registuser and gameid=x_ads.f_getgameid(v_gamecode)=1Error: PLS-00103: 出现符号 "="在需要下列之一时:
. ( * % & - + ; / at for mod
remainder rem <an exponent (**)> and or group having
intersect minus order start union where connect || multiset
Line: 26
Text: select count(username) from x_ads.registuser where username=v_registuser and gameid=x_ads.f_getgameid(v_gamecode)=1
解决方案 »
- 关于大数据量的数据库设计问题
- oracle执行expdp的时候报错
- 新手求解释
- Oracle10g RAC安装出现CRS-1006:No more members to consider问题
- ORACLE SQL问题.关于交叉表的.
- 正在导出统计 导出成功终止,但出现警告
- 有誰知道在linux下怎么看哪几個邏輯盤屬于同一硬盤驅動器的﹐我用的是Raid1+0陣列
- 如何获得colb字段的长度
- 一个有关游标变量的问题!
- 在Delphi中使用Oracle存储过程是否必须用procedure控件?不能在query中执行?
- 请教:Oracle ORA-24331 缓冲区过小的问题
- 新手问改不了user_dump_dest、backgroud_dump_dest参数的问题!
请提供函数代码呀?
select count(username) into l_count from x_ads.registuser where username=v_registuser and gameid=x_ads.f_getgameid(v_gamecode)=1;
if l_count =1 then
else
end if ;
declare
para_cnt number ;
begin
select count(username) into para_cnt from x_ads.registuser where username=v_registuser and gameid=x_ads.f_getgameid(v_gamecode)=1 ;
if(para_cnt>0) then
dbms_output.put_line('XXXXX');
end;
试试看能达到你要求不?