Organizational Research By

Surprising Reserch Topic

oracle pl sql string compare issue


oracle pl sql string compare issue  using -'sql,oracle,plsql,oracle10g,oracle11g'

1).Hello, I have the following Oracle PL/SQL codes that may be rusty from you guys perspective:

 DECLARE
 str1  varchar2(4000);
 str2  varchar2(4000);
 BEGIN
   str1:='';
   str2:='sdd';
   IF(str1<>str2) THEN
    dbms_output.put_line('The two strings is not equal');
   END IF;
 END;
 /


This is very obvious that two strings str1 and str2 are not equal, but why 'The two strings are not equal' was not printed out? Do Oracle have another common method to compare two string?
    
asked Sep 29, 2015 by devkumargupta
0 votes
6 views



Related Hot Questions



Government Jobs Opening


...