Let Us Learn Oracle - Part 30 of N [ VSize function of Oracle ]

Purpose: It returns the number of bytes in the internal representation of expression. If expression is null, it returns null.

SQL> Select EMPNAME, VSize(EMPNAME) VSizeExample
  2  From tblemployee;

EMPNAME                                            VSIZEEXAMPLE
-------------------------------------------------- ------------
Deepak Kumar Goyal                                           18
Shashi Dayal                                                 12
Amitav Mallik                                                13
Amit Ojha                                                     9
Sumanta Manik                                                13

It is similar to DataLength function in Sql Server.

Thanks for reading