Question

PLSQL if判断问题

v_xm 是空的、如何去判断这个变量 if v_xm=ISNULL then
dbms_output.put_line(1111111111);
else
dbms_output.put_line(2222222222);
end if;

Answer 1

VXML 语音变量调试2010-03-25 11:58<?xml version="1.0" encoding="UTF-8"?>

<vxml version = "2.1">

<meta name="author" content="Matthew Henry"/>
<meta name="copyright" content="2005 voxeo corporation"/>
<meta name="maintainer" content="YOUR_EMAIL@HERE.COM"/>

<form id="F_1">

<var name="AudioVar" expr="'MyAudioFile.wav'"/>

<block>
<prompt>
here we use the audio expression attribute rather than a URI for
our audio file.
</prompt>
<audio expr="AudioVar"/>
</block>
</form>

</vxml>

Answer 2

if v_xm is NULL then 不能用=isnull