table column

[feroz]

Hi,

I have few questions I would like to ask. I hope somebody could help me.

1) How to calculate each row contain how many bytes and each table contain how many bytes?

2)Can I change column name after table being created? I think the answer is NO. Just want to make sure.

3)How do you add new column to existing table?

Thank you in advance.

regards,
feroz

[Sureshy]

In answer to your first question :

http://www.dbasupport.com/forums/sho...threadid=18819

Don't think you can rename a column

But can use create table as.

to add a column :

alter table add column_definitions
e.g alter table add (quantity number (10,3)

have to work around to make new column NOT NULL if already has rows, post question here if unsure how.

[Sureshy]

sorry to add you must specify table/schema

e.g alter table schema.table_name add (column_definitions)

[feroz]

Hi again,

Thank you for your reply.

regards,
feroz