What is the purpose of Oracle's VSIZE function?

 Posted by Niladri.Biswas on 5/2/2013 | Category: Oracle Interview questions | Views: 3033 | Points: 40

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;

-------------------------------------------------- ------------
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.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response