How to find number of bytes occupied by each record in a table?
Printable View
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