Skip to content
Related Articles

Related Articles

Improve Article

PLSQL | VSIZE Function

  • Last Updated : 06 Oct, 2019

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.

Attention reader! Don’t stop learning now. Learn SQL for interviews using SQL Course  by GeeksforGeeks.

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 
My Personal Notes arrow_drop_up
Recommended Articles
Page :