OraFAQ Forum: SQL & PL/SQL » define row size of a table

Home » SQL & PL/SQL » SQL & PL/SQL » define row size of a table

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

define row size of a table [message #212379]

Fri, 05 January 2007 01:12

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

Report message to a moderator

Re: define row size of a table [message #212404 is a reply to message #212379]

Fri, 05 January 2007 03:37

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.

Report message to a moderator

Re: define row size of a table [message #212444 is a reply to message #212379]

Fri, 05 January 2007 05:38

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;

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 21:35:52 CST 2024