OraFAQ Forum: Designer » How to calculate a row size of table

Home » Developer & Programmer » Designer » How to calculate a row size of table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to calculate a row size of table [message #90763]

Tue, 02 November 2004 21:15

Anoop Rawat
Messages: 6
Registered: November 2004

Junior Member

�

can anybody pls help me.

Suppose i want to calculate the rowsize of the following table .

can pls tell me what is the formula to calculate the rowsize of table.

And what is the formula to set pctfree and pctused.

TEST>desc e123��
�Name�� Null?�� Type��
�----------------------------------------- -------- --
�ENAME�� VARCHAR2(10)��
�ENO�� NUMBER(2)��
�DOJ�� DATE��
��
Regards

Anoop Rawat

Report message to a moderator

Re: How to calculate a row size of table [message #90764 is a reply to message #90763]

Wed, 03 November 2004 06:40

andrew again
Messages: 2577
Registered: March 2000

Senior Member

select ename, vsize(ename)+vsize(eno)+vsize(doj) Row_Bytes
from e123;

Report message to a moderator

Re: How to calculate a row size of table [message #90766 is a reply to message #90764]

Thu, 04 November 2004 02:41

Anoop Rawat
Messages: 6
Registered: November 2004

Junior Member

Thanks for your reply.

Can u pls tell me what is vsize. whether it is orcale supplied package or what...

Regards
Anoop Rawat

Report message to a moderator

Re: How to calculate a row size of table [message #90769 is a reply to message #90763]

Wed, 10 November 2004 08:01

José D'Andrade
Messages: 1
Registered: November 2004

Junior Member

MS SQL Server

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=4924

Report message to a moderator

Re: How to calculate a row size of table [message #90771 is a reply to message #90766]

Fri, 12 November 2004 05:31

Ravi Kanth Perepu
Messages: 8
Registered: August 2004

Junior Member

Hi Anoop,

VSIZE returns the number of bytes in the internal representation of expr. If expr is null, then this function returns null.
its a oracle supplied function.

Note :- This function does not support CLOB data directly. However, CLOBs can be passed in as arguments through implicit data conversion.

Regards
Ravi

Report message to a moderator

Re: How to calculate a row size of table [message #90777 is a reply to message #90771]

Mon, 22 November 2004 18:15

Anoop Rawat
Messages: 6
Registered: November 2004

Junior Member

Thanks for your help .
Regds
Anoop Rawat

Report message to a moderator

Previous Topic:	contact mechanisms and addresses
Next Topic:	Not able to edit in sql prompt

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 16 05:45:54 CST 2025