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:
Subscribe to:
Post Comments (Atom)
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...
-
1) PL/SQL PROGRAM TO CUALCULATE THE NET SALARY IF DA IS 30% OF BASIC,HRA IS 10% OF BASIC AND PF IS 7% IF BASIC SALARY IS LESS THAN 8000 ,PF...
-
1.Write a program to print the following format WELCOME TO PL/SQL PROGRAMMING BEGIN DBMS_OUTPUT.PUT_LINE('WELCOME TO PL/SQL PROGRAMMING...
-
A DBMS that is based on relational model is called as RDBMS. Relation model is most successful mode of all three models. Designed by E.F. C...
No comments:
Post a Comment