Using SQL function in PL/SQL

Using Length function in PL/SQL


DECLARE

  v_desc_size INTEGER(3);
  v_prod_description VARCHAR2(70):='Hi Bhavesh';
  --get the length of the string in prod_description
 
BEGIN
  v_desc_size:= LENGTH(v_prod_description);
  dbms_output.put_line(v_desc_size);
END;

Output:

Leave a Reply

Your email address will not be published. Required fields are marked *