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:

Top 50 SQL Interview Questions & Answers

1. What is DBMS? A Database Management System (DBMS) is a program that controls creation, maintenance and use of a database. DBMS can be...