PLSQL | VSIZE Function

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 

Shubrodeep Banerjee

I am a technology enthusiast who has a keen interest in programming I am pursuing Engineering in Computer Science from GEU, Dehradun I like to unwind by watching movies and English sitcomsI have a keen interest in music