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
moorthygs
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


Cheers,

Moorthy.GS
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
amul
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?
3)constraints?

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
vijaykasi
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: Mon Dec 05 09:06:13 CST 2016

Total time taken to generate the page: 0.08896 seconds