Record Size

How to find number of bytes occupied by each record in a table?

Use this example select vsize(deptno)+vsize(dname)+vsize(loc) bsize from dept where loc='xxx'

Try this one

seletc lengthb(deptno)+lengthb(dname)+lengthb(loc) bsize from dept where loc='xxx';

Try this query select length(div_code)+length(name) as "size" from pay