locked
compare string in Oracle (Package) RRS feed

  • Question

  • User-1075092149 posted

    why i can't compare the string in package in Oracle using:

     

    v_test varchar2(10);

    begin

     

    v_test='';

     

    if(v_test='') then

    --section A

    else

    --section B

    end if;

     

    it always fall into section B, why?

    Thursday, November 15, 2012 11:20 PM

Answers

  • User269602965 posted

    try

    begin

    v_test := '';

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, November 16, 2012 3:23 PM