How to determine the size of a table one row?

Question

I like to know how to calculate the size of one row of a table.

Consider my table has entries below.

Empid Ename Age    DOB      Salary
10000 BalaS 26  12-03-2015  123456

Answer 1

This should solve your problem. Use the length () operator as shown below. This will give the exact character length in the specified column. This will also take NULL values ​​into account , NULL will be evaluated to 0 :

select length(Empid || Ename || Age || DOB || Salary)
from mytable 
where id = someId;

Answer 2

You can try the following:

select vsize(Empid) + vsize(Ename) + vsize(Age) + vsize(DOB) + vsize(Salary)
from mytable 
where id = someId;

Answer 3

, vsize ().

sql VSIZE ()