Pre Exam Test Practice (SSC | Banking | IAS | GATE | State Level | CLAT | Railways | Insurance | Teaching Exams | NDA | Defence | IES |State Exam )

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:

 str1  varchar2(4000);
 str2  varchar2(4000);
   IF(str1<>str2) THEN
    dbms_output.put_line('The two strings is not equal');
   END IF;

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

Related Hot Questions

Government Jobs Opening