PPT Slide

Using the vsize( ) function

in SELECT statements:

The vsize( ) function is not strictly for

numeric Datatypes. It gives the size in bytes

of any value for text, number, date, ROWID,

and other columns.

SELECT VSIZE(384838),

VSIZE('ORANGE_TABBY'),

VSIZE(sysdate)

FROM DUAL;VSIZE(384838) VSIZE('ORANGE_TABBY') VSIZE(SYSDATE)------------- --------------------- --------------4 12 8

40

Previous slide

Next slide

Back to first slide

View graphic version