Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 16, 2012 07:23 PM by Lannie
Member
375 Points
1033 Posts
Nov 16, 2012 03:20 AM|LINK
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?
Contributor
3742 Points
730 Posts
Nov 16, 2012 07:23 PM|LINK
try
v_test := '';
-_-
Member
375 Points
1033 Posts
compare string in Oracle (Package)
Nov 16, 2012 03:20 AM|LINK
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?
Lannie
Contributor
3742 Points
730 Posts
Re: compare string in Oracle (Package)
Nov 16, 2012 07:23 PM|LINK
try
begin
v_test := '';