• Skip to primary navigation
  • Skip to main content

Tech Honey

The #1 Website for Oracle PL/SQL, OA Framework and HTML

  • Home
  • HTML
    • Tags in HTML
    • HTML Attributes
  • OA Framework
    • Item in OAF
    • Regions in OAF
    • General OAF Topics
  • Oracle
    • statement
    • function
    • clause
    • plsql
    • sql
You are here: Home / Oracle / function / VSIZE Function in Oracle SQL – PLSQL

VSIZE Function in Oracle SQL – PLSQL

November 26, 2012 by techhoneyadmin

The VSIZE Function in Oracle SQL / PLSQL is used to get the number of bytes in the internal representation of an expression

Syntax for the using the VSIZE Function in Oracle SQL / PLSQL is:

SELECT VSIZE(expression)
FROM table_name;
expression is the string to be evaluated.

Examples:

Using VSIZE Function in Oracle SQL / PLSQL SELECT statement:

SELECT VSIZE('Tech Honey')
FROM dual;

Will return ‘10’

SELECT VSIZE('Tech')
FROM dual;

Will return ‘4’

SELECT VSIZE('Tech Honey is a good website')
FROM dual;

Will return ‘28’


Filed Under: function Tagged With: how to use VSIZE Function in oracle database query, how to use VSIZE Function in oracle plsql, how to use VSIZE Function in oracle sql, syntax and example of VSIZE Function in oracle database query, syntax and example of VSIZE Function in oracle plsql, syntax and example of VSIZE Function in oracle sql, using VSIZE Function in oracle database query, using VSIZE Function in oracle plsql, using VSIZE Function in oracle sql, VSIZE Function in oracle plsql, VSIZE Function in oracle sql, VSIZEPLSQL

Copyright © 2023 · Parallax Pro on Genesis Framework · WordPress · Log in