<s id="2e0qm"><div id="2e0qm"></div></s>
<div id="2e0qm"><button id="2e0qm"></button></div>
<small id="2e0qm"></small>
<div id="2e0qm"></div>
<div id="2e0qm"><s id="2e0qm"></s></div>
<div id="2e0qm"><button id="2e0qm"></button></div>
主頁 > 知識庫 > 數據庫 > Oracle >

oracle空串比較

來源:中國IT實驗室 作者:佚名 發表于:2013-07-16 15:43  點擊:
oracle空串比較 declare len_x integer; len_y integer; begin select nvl(length(trim()), 0) into len_x from dual; select nvl(length(trim(null)), 0) into len_y from dual; dbms_output.put_line(len_x= || len_x); dbms_output.put_line(len_y= || len
oracle空串比較  declare
  len_x integer;
  len_y integer;
  begin
  select nvl(length(trim('')), 0) into len_x from dual;
  select nvl(length(trim(null)), 0) into len_y from dual;
  dbms_output.put_line('len_x=' || len_x);
  dbms_output.put_line('len_y=' || len_x);
  if len_x = len_y then
  dbms_output.put_line('1111');
  else
  dbms_output.put_line('2222');
  end if;
  end;

    有幫助
    (0)
    0%
    沒幫助
    (0)
    0%
    真人女荫道口100种图片
    <s id="2e0qm"><div id="2e0qm"></div></s>
    <div id="2e0qm"><button id="2e0qm"></button></div>
    <small id="2e0qm"></small>
    <div id="2e0qm"></div>
    <div id="2e0qm"><s id="2e0qm"></s></div>
    <div id="2e0qm"><button id="2e0qm"></button></div>