Posted by visu on 06/12/07 07:35

I want to know following memory space related question.


1 . How can i get a Database Size by means of a SQL query?

2. How can i Get a field size (not allocated space) .. ie. i am
storing some textual data to a field..
after a insertion i want to know how much space has been occupied by
that particular field .

ex sno product_name Description
1 sample1 dfkjsdkfj kldsjfkdjk
sdkjdfskdjk vcmvxcvmcvnksdjfkdsn m

Here i want know the space occupied by the field name "description"
for the product id=1.

Thanks in adavance

Regards
Visu.

• Next in forum: Re: How calculate space that occupied?
• Prev in forum: Re: float storage and usage
• Thread view: How calculate space that occupied?

[Reply to this message]