Home » SQL & PL/SQL » SQL & PL/SQL » define row size of a table
define row size of a table [message #212379] Fri, 05 January 2007 01:12 Go to next message
Messages: 3
Registered: January 2007
Location: Chennai
Junior Member
Hi All,

I want to create a table in my database.

How to define the rowsize for that table.

What are the things to be taken care for creating a new table.

Thanks in Advance


icon2.gif  Re: define row size of a table [message #212404 is a reply to message #212379] Fri, 05 January 2007 03:37 Go to previous messageGo to next message
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
1)what is the need for you to create this table?
2)is it going to have foreign keys?

it goes on..i suggest you better stop asking and start reading introduction to SQL.
Re: define row size of a table [message #212444 is a reply to message #212379] Fri, 05 January 2007 05:38 Go to previous message
Messages: 11
Registered: January 2007
Location: London
Junior Member
You can use below query to find average rowsize for each column

select avg(nvl(vsize(column_name), 0)) "Space of an average row",
count(*) "Number of Rows"
from table_name;
Previous Topic: get list of months between from_date and to_date
Next Topic: PLS-00201:identifier 'PROJECT_FROM_TEMPLATE' must be declared.
Goto Forum:

Current Time: Sun Oct 23 04:49:37 CDT 2016

Total time taken to generate the page: 0.04584 seconds