If you are a PL/SQL beginner or want to start learning, then keep your close attention in this tutorial as we are going to share how to write a PL/SQL block to differentiate between CHAR and VARCHAR2 datatype.
Copy the below PL/SQL program and execute it. In this program, we are going to share a PL/SQL.
SET SERVEROUTPUT ON;
f_name CHAR(15 CHAR);
l_name VARCHAR2(15 CHAR);
f_name := 'Allen ';
l_name := 'Munra ';
DBMS_OUTPUT.PUT_LINE('*' || f_name || '*');
DBMS_OUTPUT.PUT_LINE('*' || l_name || '*');
Prem Tiwari is the founder of FreeWebMentor.com and also a professional developer who has vast experience in PHP and open source technologies. Apart from this, he is a blogger by hobby and also he has been a regular speaker of WordPress sessions in various IT Companies. View all posts by Prem Tiwari