Open In App

PLSQL | VSIZE Function

Improve
Improve
Like Article
Like
Save
Share
Report

The PLSQL VSIZE function is used for returning the number of bytes in the internal representation of an expression. The PLSQL accepts only one parameter which specifies the expression.

Generally, the VSIZE function returns a numeric value but if the expression is Null then this function returns null. This function does not support CLOB data directly. However, CLOBs can be passed in as arguments through implicit data conversion.

Syntax:

VSIZE( expression )

Parameters Used:

expression – It is used to specify the string which needs to be evaluated.

Supported Versions of Oracle/PLSQL:

  1. Oracle 12c
  2. Oracle 11g
  3. Oracle 10g
  4. Oracle 9i
  5. Oracle 8i

Return Value:
The VSIZE function in PLSQL returns a numeric value.

Example-1: Passing an input string with only characters.

DECLARE 
   Test_String string(20) := 'Geeksforgeeks';
   
BEGIN 
   dbms_output.put_line(VSIZE(Test_String)); 
   
END;  

Output:

13 

Example-2: Passing an input string with characters and blank spaces.

DECLARE 
   Test_String string(20) := ' Geeksforgeeks ';
   
BEGIN 
   dbms_output.put_line(VSIZE(Test_String)); 
   
END;  

Output:

15 

Example-3: Passing a NULL argument.

DECLARE 
   Test_String string(20) := '';
   
BEGIN 
   dbms_output.put_line(VSIZE(Test_String)); 
   
END;  

Output:

NULL 

Example-4: Passing blank space as an argument.

DECLARE 
   Test_String string(20) := ' ';
   
BEGIN 
   dbms_output.put_line(VSIZE(Test_String)); 
   
END;  

Output:

1 

Last Updated : 06 Oct, 2019
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads