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:

No comments:

Post a Comment

SQL Interview Questions and Answers

There is given sql interview questions and answers that has been asked in many companies. For PL/SQL interview questions, visit our next...