Thursday, 28 July 2011

2nd PL /SQL Program

DECLARE

emp_name_c CHAR(32);
emp_name_v VARCHAR(32);
BEGIN

emp_name_c := 'sateesh.bagadhi';
emp_name_v := 'sateesh.bagadhi';

IF emp_name_c = emp_name_v THEN
DBMS_OUTPUT.PUT_LINE('The names are the same');
ELSE
DBMS_OUTPUT.PUT_LINE('The names are NOT the same');

END IF;
END;
/

output:

Thursday, 28 July 2011

2nd PL /SQL Program

DECLARE

emp_name_c CHAR(32);
emp_name_v VARCHAR(32);
BEGIN

emp_name_c := 'sateesh.bagadhi';
emp_name_v := 'sateesh.bagadhi';

IF emp_name_c = emp_name_v THEN
DBMS_OUTPUT.PUT_LINE('The names are the same');
ELSE
DBMS_OUTPUT.PUT_LINE('The names are NOT the same');

END IF;
END;
/

output: