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 


My Personal Notes arrow_drop_up

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

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.




Article Tags :
Practice Tags :


Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.