What is the purpose of Oracle's VSIZE function?

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

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

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.

Asked In: Many Interviews | Alert Moderator